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

Course Info:

SQL Fundamentals

Beginner

The average completion time for this course is 10-hours.

This course requires a basic subscription and includes four 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

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit