Remove Duplicates with DISTINCT
SELECT DISTINCT removes duplicate rows from the result. SELECT city FROM customers returns six rows, one per customer; SELECT DISTINCT city keeps only one row for each city. NULL also remains in the result as one row.
GOAL
Predict how many rows remain after DISTINCT.
SELECT DISTINCT city FROM customers returns how many rows?