MISSION 253

Summary Statistics

Learn how to calculate summary statistics in SQL.

Objectives

  • Learn how to use aggregate functions in SQL.
  • Learn to compute mix, max, and average values in a column.
  • How to perform arihmetic in SQL.

Mission Outline

1. Introduction
2. Finding a Column's Minimum and Maximum Values in SQL
3. Calculating Sums and Averages in SQL
4. Combining Multiple Aggregation Functions
5. Customizing The Results
6. Counting Unique Values
7. Performing Arithmetic in SQL
8. Next Steps
9. Takeaways

sql-fundamentals

Course Info:

SQL Fundamentals

Beginner

The median completion time for this course is 6.3 hours.

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