Download · SQL & Databases

SQL Joins Practice Pack

Practice prompts for inner joins, left joins, grouping, duplicates, and common reporting mistakes.

Resource profile

Intermediate
45 min
Download
Download MarkdownResource libraryLearner downloads

Resource output

Ready-to-use starter asset

Practice prompts for joining learner, enrollment, progress, and quiz data into useful reports.

SQL Joins Practice Pack

Use this as a first draft, then adapt it for your organization, environment, training audience, or certification objective.

Open SQL practice toolView SQL courses

Resource contents

Practice Dataset

  • learners(id, full_name, organization)
  • courses(id, title, track)
  • enrollments(learner_id, course_id, status, enrolled_at)
  • quiz_attempts(learner_id, course_id, score, completed_at)

Prompts

  • Return every learner and their active course count, including learners with zero active courses.
  • Find courses with enrollments but no quiz attempts in the last 30 days.
  • Calculate average quiz score by course and sort from lowest to highest.

Checks

  • Confirm the join key before writing the query.
  • Watch for duplicate rows before aggregating.
  • Use left joins when the report must include missing activity.

Related resources

Continue with nearby library assets from the same learning domain.

More resources in this category can be added through the admin resource manager after Supabase is activated.