Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Counting and Summarizing: PostgreSQL: Uncharted

Courses PostgreSQLCounting and Summarizing

Counting and Summarizing

Turn detailed cafe and gym rows into counts, totals, averages, grouped reports, and filtered summaries.

PostgreSQL
Unit 4 of 12
10 lessons
91 min
220 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

10 total

1One Number from ManyCount all order-line rows with an aggregate function.CodeConcept6 min20 XPOpen
2Sums and AveragesSummarize calculated line totals with SUM, AVG, MIN, and MAX.CodeConcept9 min20 XPOpen
3Counting CarefullyCompare row counts, non-NULL counts, and distinct value counts.CodeConcept8 min20 XPOpen
4GROUP BYCount order lines separately for each menu item.CodeConcept8 min20 XPOpen
5Grouping on MoreGroup by multiple columns and by a calculated date expression.CodeConcept11 min20 XPOpen
6Filtering Groups with HAVINGKeep only grouped items whose aggregate count exceeds a threshold.CodeConcept8 min20 XPOpen
7WHERE vs HAVINGChoose row filtering or group filtering for three report requirements.InteractiveConcept7 min20 XPOpen
8Summing the GymCount gym visits by local weekday and by member.CodePractice11 min20 XPOpen
9Aggregation WorkoutBuild a grouped sales report with row and group filters and exact ordering.CodePractice12 min20 XPOpen
10Aggregation Mastery CheckSummarize qualified customer groups with several aggregate functions.CodeMastery check11 min40 XPOpen

Shaping Values Working Across Tables