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:

SQL Fundamentals for R Users

Beginner

The average completion time for this course is 3 –4-hours.

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