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