Aggregate Functions

123456789101112131415
Across
  1. 2. Specifies the table to get data from
  2. 4. Keyword used to rename the output of an aggregate function
  3. 5. A command to get data from a database
  4. 6. Removes duplicate values in aggregation
  5. 9. Returns the largest value in a column
  6. 10. Calculates the average of numeric values
  7. 11. Keyword used to group rows that have the same values
  8. 12. SQL keyword used to choose data to be retrieved
  9. 13. Special value ignored by most aggregate functions
  10. 14. Collection of rows and columns in a database
  11. 15. Adds all the values in a numeric column
Down
  1. 1. Aggregate functions are applied to this part of a table
  2. 3. Used to filter groups based on aggregate results
  3. 7. Counts the number of rows in a table
  4. 8. Filters rows before aggregation
  5. 9. Returns the smallest value in a column
  6. 10. Another name for a column or table