praxis.ibLog in
A3.3 Database programmingA3.3.4

Calculations using SQL aggregate functions

Construct calculations within a database using SQL's aggregate functions

AHL≈ 55 minCommand term: ConstructPremium

In this lesson

  • Using AVG, COUNT, MAX, MIN and SUM on a whole table or on the rows WHERE selects
  • Calculating one result per group with GROUP BY, and filtering groups with HAVING
  • Combining aggregates with joins to produce reports that support decisions

This lesson is part of Premium

Every topic has one free lesson. Premium unlocks every interactive lesson, the exam-style questions at the end of each one, and the rest of Praxis IB.

Log in or sign upTry the free lesson: A3.3.1 Data language types within SQL

What's inside

  1. LearnAggregate functions
  2. LearnAggregates on grouped data
  3. CheckQuick check
  4. LabReport on the print shop
  5. ExamWorked exam answer
  6. ReviewMistakes examiners see
  7. Exam practiceExam-style questions

Ends with 5 exam-style questions worth 14 marks, with a self-marking markscheme.