Module 6 · You are here

Summarizing and Sharing: GROUP BY, COUNT, Saved Queries

Turn rows into a finding. Group, count, save the query so a teammate can re-run it next month, and submit the Organizer Query Brief : the final artifact of the course.

Time~20 minutes

BadgeBrief Finisher

DeviceDesktop recommended

ArtifactSubmitted Organizer Query Brief

By the end of Module 6, you will be able to:

Use COUNT(*), COUNT(DISTINCT col), SUM, AVG, MIN, and MAX.
Group results with GROUP BY.
Filter groups with HAVING and explain why it's different from WHERE.
Use LIKE with % for pattern matching.
Save a query in BigQuery with a name and description.
Share results through CSV, Sheets, Looker Studio, or a saved BigQuery table.
Write a one-paragraph plain-language finding for a non-technical reader.

Subsections in Module 6

6.1

From rows to counts

4 min

Open 6.2

GROUP BY

4 min

Open 6.3

HAVING and LIKE

4 min

Open 6.4

Save and share

5 min

Open 6.5

Submit the brief

3 min

Open

Start here: Module 6.1 · From rows to counts

Begin Module 6

After Module 6: Course complete.

Back to course overview