Part -2 Capstone Project
SQL Education — Part 2Intermediate Education SQL Queries — Interactive Capstone
CAPSTONE TASK
SQL Education — Part 2
SELECT Retrieval · WHERE Filtering · Education Joins · Enrollment & Class Analysis · Teaching Assignments · GROUP BY · HAVING · Active Students · Capacity · Multi-Course Enrollments · Teaching Loads
Canonical database
education_admin_sql_course
Core Part 2 relationships
students.program_id → programs.program_id
instructors.department_id → departments.department_id
sections.course_id → courses.course_id
sections.term_id → terms.term_id
enrollments.section_id → sections.section_id
teaching_assignments.instructor_id → instructors.instructor_id
Part 2 SQL
SELECT · WHERE · JOIN · COUNT(*) · GROUP BY · HAVING
SELECT Retrieval · WHERE Filtering · Education Joins · Enrollment & Class Analysis · Teaching Assignments · GROUP BY · HAVING · Active Students · Capacity · Multi-Course Enrollments · Teaching Loads
Canonical database
education_admin_sql_course
Core Part 2 relationships
students.program_id → programs.program_id
instructors.department_id → departments.department_id
sections.course_id → courses.course_id
sections.term_id → terms.term_id
enrollments.section_id → sections.section_id
teaching_assignments.instructor_id → instructors.instructor_id
Part 2 SQL
SELECT · WHERE · JOIN · COUNT(*) · GROUP BY · HAVING
Hint 1 — Reasoning clue
A conceptual clue is available.
Hint 2 — More specific
A more specific clue is available.
Show Solution
script.sqlComplete the SQL Education SQL
OUTPUT
Run your SQL to check the education SQL analysis result.
✦ AI Tutor
