A SELECT expression that is embedded within one of the clauses of a SELECT statement is a subquery. True False Which aggregate function returns a count of all non-null values returned by a value expression? COUNT(*) MAX(value expression) SUM(value expression) COUNT(value expression) When an aggregate function is used as a search condition it must be placed in an aggregate function. True False A table query is an embedded SELECT expression that returns only one column and no more than one row. True False Grouping data with aggregate functions enables you to see subtotals for categories of data. True False An OUTER JOIN returns only those rows where the linking values match in both of the tables True False An INNER JOIN returns all rows from the first table and any matching rows from the second table. True False Filters that use a predicate on an aggregate function must be placed in a WHERE clause. True False What SELECT statement clause cannot be used when embedded in a JOIN? HAVING GROUP BY WHERE ORDER BY The SQL standard provides a set of __ functions that enable you to calculate a single value from the rows in a result set or from the values returned by a value expression. aggregate mathematical calculation summary