CO1: Aggregate Functions

123456789101112131415
Across
  1. 6. Returns the number of rows matching a condition
  2. 7. Middle value in an ordered set of numbers
  3. 8. Function that performs a calculation on multiple values
  4. 10. Measures the spread of numbers in a dataset
  5. 13. Counts the number of unique values
  6. 15. Returns the largest value in a column
Down
  1. 1. Clause to filter groups after aggregation
  2. 2. Keyword to eliminate duplicate values in aggregation
  3. 3. Opposite of aggregate function, returns single value per row
  4. 4. Returns the total of numeric values in a column
  5. 5. Calculates standard deviation
  6. 7. Most frequently occurring value in a dataset
  7. 9. Clause used to arrange rows for aggregation
  8. 11. Calculates the average of numeric values
  9. 12. Returns the smallest value in a column
  10. 14. Another term often used for the sum result