You need to be able to:

• Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables:
  • UPDATE, SELECT, DELETE, INSERT statements making use of:
    • wildcards
    • aggregate functions (MIN, MAX, AVG, SUM, COUNT)
    • computed values, alias
    • GROUP BY
    • ORDER BY
    • WHERE