SQL Query Quiz

Which of the following queries returns 'Palo Alto'?

• SELECT customer_city FROM Customers WHERE customer_name = 'Hayes';

• SELECT customer_city FROM Customers WHERE customer_name = 'Johnson';

• SELECT customer_city FROM Customers WHERE customer_street = 'Main';

• SELECT customer_city FROM Customers WHERE customer_street = 'Park';

Which query lists all the unique cities?

• SELECT customer_city FROM Customers;

• SELECT DISTINCT customer_city FROM Customers;

• SELECT UNIQUE customer_city FROM Customers;

• SELECT customer_city GROUP BY customer_city FROM Customers;

Which query returns the names of all customers in 'Rye'?

• SELECT customer_name FROM Customers WHERE customer_city = 'Rye';

• SELECT customer_name FROM Customers WHERE customer_city = 'Harrison';

• SELECT customer_name FROM Customers WHERE customer_street = 'North';

• SELECT customer_name FROM Customers WHERE customer_street = 'Main';

Which query returns all the information for 'Turner'?

• SELECT * FROM Customers WHERE customer_name = 'Turner';

• SELECT * FROM Customers WHERE customer_city = 'Stamford';

• SELECT customer_name, customer_street FROM Customers WHERE customer_name = 'Turner';

• SELECT customer_city, customer_street FROM Customers WHERE customer_name = 'Turner';

Which query finds customers whose names start with 'J'?

• SELECT customer_name FROM Customers WHERE customer_name LIKE 'J';

• SELECT customer_name FROM Customers WHERE customer_name LIKE 'J%';

• SELECT customer_name FROM Customers WHERE customer_name LIKE '%J';

• SELECT customer_name FROM Customers WHERE customer_name = 'J';

Which query counts the number of customers in each city?

• SELECT customer_city, COUNT(*) FROM Customers;

• SELECT customer_city, COUNT(*) FROM Customers GROUP BY customer_city;

• SELECT COUNT(*), customer_city FROM Customers GROUP BY customer_city;

• SELECT customer_city, SUM(*) FROM Customers;

Which query lists all street names alphabetically?

• SELECT customer_street FROM Customers ORDER BY customer_street;

• SELECT customer_street FROM Customers SORT BY customer_street;

• SELECT customer_street FROM Customers ORDER customer_street;

• SELECT customer_street FROM Customers GROUP BY customer_street;

Which query finds customers whose street name is 'Main'?

• SELECT customer_name FROM Customers WHERE customer_street = 'Main';

• SELECT customer_name FROM Customers WHERE customer_street LIKE 'Main';

• SELECT customer_name FROM Customers WHERE customer_street = '%Main%';

• SELECT customer_name FROM Customers WHERE customer_street LIKE '%Main%';

Which query returns the number of distinct cities?

• SELECT COUNT(DISTINCT customer_city) FROM Customers;

• SELECT COUNT(customer_city) FROM Customers;

• SELECT DISTINCT COUNT(customer_city) FROM Customers;

• SELECT UNIQUE COUNT(customer_city) FROM Customers;

Which query finds the city with the fewest customers?

• SELECT customer_city FROM Customers GROUP BY customer_city ORDER BY COUNT(*) ASC LIMIT 1;

• SELECT customer_city FROM Customers GROUP BY customer_city ORDER BY COUNT(*) DESC LIMIT 1;

• SELECT customer_city FROM Customers ORDER BY COUNT(*) ASC LIMIT 1;

• SELECT customer_city FROM Customers WHERE COUNT(*) = 1;