MISSION 253

Summary Statistics

In our summary statistics SQL mission, learn how to calculate summary statistics in SQL. Calculating statistics of a dataset is an important skill to have because you can quickly explore any dataset, and explore the basics of a dataset beyond a SELECT statement. Building on the previous mission, you'll continue your journey and gradually grow your skills to ensure you are proficient and prepared to land your first job in data!

In this mission, you will learn how to compute the minimum and the maximum of a column using the MIN and MAX functions. You will also learn how to calculate sum and averages of numerical columns using the SUM and AVG functions. In addition to learning how to use aggregate functions, you will also learn how perform arithmetic in SQL using the four mathematical operators (+, -, *, /).

While learning about each of the above clauses, you will be working with a bit of data that contains the 2010-2012 data for college grads. This dataset contains information on job outcome statistics based on college majors. With each concept, you'll be using our code running system with answer checking so you can ensure you've mastered each concept before moving on to the next concept.

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:

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