06.Remove Duplicates

Each task asks for a list without repeats.

Each city that has a department, once: city.
Think before you run it: how many rows does SELECT DISTINCT customer_id FROM orders; return?
Each different pair of title and department_id in employees, sorted by department_id, then title: department_id, then title.
Each different product price, from highest to lowest: price.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT city FROM departments;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 40/4 done

Each department city once
One column, city. Toronto has two departments; list it once.