The HAVING clause can be used for what purpose?

True or False? This query is valid the way it is structured. SELECT * FROM Prospects WHERE assignment_type <> 'Team' AND criteria is not null

What clause is used to sort data and group it?

What keyword is used to check for a range of values?

What happens if you omit the WHERE clause in a SQL DELETE query?

Which symbol can be used to indicate a "wild card" to substitute for one or more characters when searching for string in a database?

The action of including only some columns for output while retrieving data is known as ____.

The ________ keyword is required to use relational operators in a case statement.

The _____ operator could be used in place of minus if the dbms does not support it.

The _____ command replaces the ***** in the syntax of the update command, shown above.

The ____ wildcard symbol represents any individual character.