SQL Syntax

1234567891011
Across
  1. 1. Clause that organizes rows sharing a common value.
  2. 4. Clause used to filter rows before grouping.
  3. 6. Combines rows from two tables based on a related column
  4. 8. Type of join that returns only matching records from both tables.
  5. 9. Aggregate function that computes a mean value.
  6. 11. Aggregate function that tallies rows.
Down
  1. 2. Clause that controls the sorting of query results.
  2. 3. Restricts how many rows a query returns.
  3. 5. Clause that filters groups created by an aggregate.
  4. 7. Statement used to choose columns from a table.
  5. 10. Keyword used to rename a column or table.