You are working with a database table that contains invoice data. The table includes columns for invoice_id and billing_city. You want to remove duplicate entries for billing city and sort the results by invoice ID.
You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the billing_city column.
NOTE: The three dots (...) indicate where to add the clause.
1
2
3
4
5
SELECT ...
FROM
invoice
ORDER BY
invoice_id
RunReset
What billing city appears in row 15 of your query result?
1 point
Reno
Santiago
Oslo
London