| A | B |
|---|
| GROUP BY | divides the rows in a table into groups. |
| subquery | is a SELECT statement that is embedded in a clause of another SELECT statement. |
| inner query | also called the subquery; it returns a value that is used by the outer query. |
| embedded | to enclose snugly or firmly. Within something else. |
| Group Functions | operates on sets of rows to give one result per group. |
| HAVING | is used to specify which groups are to be displayed; restricts groups that do not meet group criteria. |
| Single-row subquery | returns only one row from the inner SELECT statement. |
| outer query | also called the main query; it accepts a value from the inner query to solve its original query. |
