SQL Quiz

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

What is the purpose of  *?

• Selects ALL fields from the table
• Selects only the first field in the table
• Selects the last field in the table
• Shows only the first row in the table

Return only the customers who have ER anywhere in their last name. 

• last_name LIKE "%er%"
• last_name = "%er"
• last_name = "%er%"
• last_name LIKE "%er"

To find the total dollar value of sales, use which? 

• SUM
• COUNT
• MAX
• MIN

AVG, COUNT, MAX, MIN and SUM are known as what?

• Aggregate functions
• Wildcard filters
• Subqueries
• Calculated field

You must always use _____ when filtering string values.

• quotes
• astericks
• exclamation point
• percent signs

What is the correct order of clauses? 

• SELECT, FROM, ORDER BY, WHERE
• SELECT, FROM, WHERE, ORDER BY
• SELECT, WHERE, FROM, ORDER BY
• WHERE, FROM, SELECT, ORDER BY

Use what to separate multiple table names in the FROM clause?

• commas
• periods
• spaces
• semicolons

To join a table, connect the ___________ of one table to the ___________ of the other.

• primary key, foreign key
• group by clause, primary key
• filtered by, foreign key
• aggregate function, where clause

Which clause allows you to SORT data?

• ORDER BY
• WHERE
• FROM
• HAVING