Please enable JavaScript to use CodeHS

Introduction to SQL

SQL Functions

Students will learn how to perform data analysis using SQL’s built-in functions. They will use aggregate functions like COUNT and SUM, group data using GROUP BY, filter grouped results with HAVING, and limit result sets using LIMIT. These skills allow students to summarize and extract insights from larger datasets effectively.

Lessons

3.1 Counting in SQL

  • The COUNT Function
  • Number of Houses
  • Number of Weasleys
  • Number of Students in Transfigurations
  • People with Z names

3.2 Grouping

  • The GROUP BY Clause
  • Grouping Results
  • People in Houses
  • Course Enrollments
  • How Many Hufflepuffs?
  • +1 more

3.3 Filtering Calculations

  • How to Filter with HAVING
  • Popular Houses
  • Full Courses
  • Families
  • C-Courses

3.4 Limiting

  • LIMIT
  • LIMIT Examples
  • Graduation
  • Bookworms
  • Rate My Professor

Courses that include this module