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
