MISSION 365

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 With GROUP BY
3. Practice: Using GROUP BY
4. Querying Virtual Columns With the HAVING Statement
5. Rounding With ROUND
6. Nesting Functions
7. C​hange Variable Types With C​AST
8. Next Steps
9. Takeaways

sql-fundamentals

Course Info:

Beginner

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

This course requires a basic subscription and includes four missions and one guided project.  It is the fifth course in the ​Data Analyst in R Path​​​

START LEARNING FREE

Take a Look Inside