Task: SELECT DISTINCT on Multiple Columns in PostgreSQL
Task: SELECT DISTINCT on Multiple Columns in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL script that updates rows in a table where a combination of two columns is unique. Specifically, you need to update all sales records to 'ACTIVE' status where the combination of…
The task
Write a SQL script that updates rows in a table where a combination of two columns is unique. Specifically, you need to update all sales records to `'ACTIVE'` status where the combination of `saleprice` and `saledate` appears only once in the table (i.e., there are no duplicate sales with the same price on the same…
Part of PrimeIntellect/Terminal-Lego-15k.