Practice Exam (SQL)

Question #1

Display all cities of customers who have ordered from Nancy Davolio and live in the United States or any other North American countries (Canada or Mexico). There should be no duplicate cities in the output and all cities should be displayed in alphabetical order. Do not include any other fields in your output.

SELECT DISTINCT customers.City
FROM customers
JOIN orders ON orders.CustomerID = customers.CustomerID
Must purchase SQL Cram Kit to see the rest!


This is the end of the preview. To unlock the rest, get the SQL Cram Kit, Lifetime Access or BUS 104 Cram Kit Bundle.

Already purchased? Click here to log in.