False. The AND operator can be used only in the WHERE clause.
False. The ANY operator cannot take an expression list.
<>ANY and <>ALL
False. The NULL values are not considered.
False. The SUM function returns a total for a group of rows.
The HAVING clause is used to constrain the groups returned by the GROUP BY clause. Therefore, it is closest to the WHERE clause in functionality.
False; you do not need the GROUP BY clause unless you have non-aggregated column data in your query.
False, the statement does not contain the column to group by or the GROUP BY clause, so it will display the sum of all salaries.
False. The innermost function is always resolved first when embedding functions within one another.