Skip to main content
SQL-BASICS5 MIN READ

Training Attendance: Ask the Missing Aggregate Question

Ask a clarifying question that defines row eligibility before an aggregate is calculated.

Imani needs to respond before writing the average-attendance query. Choose the line that defines the aggregate evidence. Learning operations manager standing beside a small conference table with a laptop open, analyst listening with notebook, modern office training room, no text, words, letters, numerals, logos. A manager asks for average class attendance by instructor before a leadership meeting. The manager asks for average attendance by instructor. Can you send average attendance by instructor before noon? fromTop https://oylytksvdaqzqcpcfhxp.supabase.co/storage/v1/object/public/omie-images/nugget-scenes/ea650046-c7f4-49d9-b139-1920cc7e03ec-18.png Analyst at the same conference table pausing thoughtfully with a laptop and schedule cards nearby, manager waiting, clean office training room, no text, words,…

Read the full lesson

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in

← Back to library