MISSION 254

Group Summary Statistics

Learn how to compute statistics across groups.

Objectives

  • Learn how to compute group level summary statistics in a database table.
  • Learn how to query virtual colums within a group.

Mission Outline

1. Introduction
2. Calculating Group-Level Summary Statistics
3. Practice: Using GROUP BY
4. Querying Virtual Columns With the HAVING Statement
5. Rounding Results With the ROUND() Function
6. Nesting functions
7. Casting
8. Next Steps
9. Takeaways

sql-fundamentals

Course Info:

Beginner

The median completion time for this course is 6.3 hours. View Details

This course requires a basic subscription and includes five missions and one guided project.  It is the 11th course in the Data Analyst in Python path and the Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside