Learn

Advanced Aggregates

Introduction

At the heart of every great business decision is data. Since most businesses store critical data in SQL databases, a deep understanding of SQL is a necessary skill for every data analyst.

Chief among data analysis tasks is data aggregation, the grouping of data to express in summary form. We’ll be working with SpeedySpoon, a meal delivery app. The folks at SpeedySpoon have asked us to look into their deliveries and help them optimize their process.

This course was developed in partnership with our good friends at Periscope Data. If you’re new to SQL, we recommend you do this course first.

Instructions

Complete each query by replacing the comments /**/ with SQL code.

We’ll start by looking at SpeedySpoon’s data. The orders table has a row for each order of a SpeedySpoon delivery. It says when the order took place, and who ordered it.

Add code to the select statement to select all columns in the orders table.

select *
from /**/
order by id
limit 100;

Note that the order and limit clauses keep the data organized.

The order_items table lists the individual foods and their prices in each order.

Complete the query to select all columns in the order_items table.

select * 
from /**/
order by id
limit 100;

Sign up to start coding

Or sign up using:

Already have an account?