Databases:

Implementation 2: Aggregate Functions

From the SQA Course Specification

• Exemplify a design of a solution to a query: fields, search criteria, grouping

• Describe, exemplify, and use SQL operations for pre-populated relations databases, with three or more linked tables:

  • UPDATE, SELECT, DELETE, INSERT statements making use of:

    • aggregate functions (MIN, MAX, AVG, SUM, COUNT)

    • GROUP BY