Please enable JavaScript to use CodeHS

Introduction to SQL

Data Aggregation

Students will explore how to aggregate and analyze data using SQL. They will work with a new HousePoint table to calculate totals, ranks, and summaries across different groups using functions like SUM and clauses like GROUP BY, HAVING, and LIMIT. Students apply these tools to rich, real-world-inspired scenarios to draw meaningful insights from data.

Lessons

4.1 House Points

  • The HousePoint Table
  • HousePoint Table
  • HousePoints With Houses
  • Gryffindors With House Points
  • Negative Points

4.2 Summing Points

  • The SUM Function
  • SUM Example
  • Harry's Points
  • Snape, Snape, Severus Snape
  • Ravenclaw Points

4.3 Point Distributions

  • Best Students
  • Debbie Downer
  • House Cup Standings
  • House Cup Winner
  • The Best Weasley
  • +2 more

Courses that include this module