Chapter 6 Study Questions Flashcards
______ functions operate on a single value and return a single value.
Scalar
_________ functions operate on a series of values and return a single value.
Aggregate
An _________ function is sometimes referred to as a column function because it operate on values in columns.
aggregate
An _______ _____ is one that contains one or more aggregate functions.
summary query
Use the ________ keyword to eliminate duplicate values.
DISTINCT
An aggregate function that returns the average of the non-null values in the expression (argument) ___.
AVG
The total of the non-null values in the expression is obtained with the ___ function.
SUM
The ___ function is invoked to find the lowest non-null value in the expression.
MIN
To return the highest non-null value in the expression, invoke the ___ function.
MAX
_____ with argument [ALL | DISTINCT] expression is invoked to find the number of non-null values in the expression.
COUNT
To find the number of rows in a table, invoke the _____ function with an asterisk as the expression(argument).
COUNT
A SELECT statement with a _____ __ clause groups the rows of a result based on one or more columns or expressions.
GROUP BY
The ______ clause specifies a search condition for a group or aggregate.
HAVING
If aggregate functions are included in the SELECT clause, the aggregate is calculated for each group specified by the _____ __ clause.
GROUP BY
When a _____ clause is included in a SELECT statement that uses grouping and aggregates, MySQL applies the search condition before it groups the rows and calculates the aggregates.
WHERE
Including a ______ clause in a SELECT statement that uses grouping and aggregates causes MySQL to apply the search condition after it groups the rows and calculates the aggregates.
HAVING
The AND or OR operators may be used to compound search condition in a ______ clause just as may be done in a _____ clause.
HAVING, WHERE
