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!

PAID CONTENT

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

Already purchased? Click here to log in.