Rewrite the following expression using the CONCAT function.

last_name || ', ' || first_name

What are two ways that you can indicate a comment in a SQL command?

The SQL engine converts the IN operator to a series of ________.

Rewrite the following WHERE clause to be case insensitive.

where job_title like '%Manager%';

What is the only group function that counts NULL values in its calculation without using NVL or other special processing?

The query results from using aggregate functions with a GROUP BY clause can be filtered or restricted by using what clause?

Identify the two special characters used with the LIKE operator and describe what they do.

Name two aggregate functions that work only on numeric columns or expressions and two other aggregate functions that work on numeric, character, and date columns.

Put the clauses of a SQL SELECT statement in the order in which they are processed.

Which operator can do valid comparisons to columns with NULL values?

The SQL engine converts the BETWEEN operator to ___________.

Where do NULL values end up in a sort operation?