Click here to navigate the course.
Drag the edges to resize the window.
In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!
We can do that same thing for other aggregates like SUM(). For instance, if we wanted to sum the total flight distance and compare that to the sum of flight distance from a particular airline (in this case, United Airlines) by origin airport, we could run the following query:
SELECT origin, sum(distance) as total_flight_distance, sum(CASE WHEN carrier = 'UA' THEN distance ELSE 0 END) as total_united_flight_distance
FROM flights
GROUP BY origin;