Part -1 Capstone Project
SQL Education — Part 1Education Data Foundations — Interactive Capstone
CAPSTONE TASK
SQL Education — Part 1
Education Administration Tables · Data Levels · Academic/Enrollment/Attendance/Advising/Tuition Systems · Key Education Fields · Education Data Flow · Table Connections
Canonical database
education_admin_sql_course
Core Part 1 tables
students · programs · courses · sections · instructors · enrollments · attendance · tuition_payments · advising_sessions
Part 1 SQL
SELECT · DISTINCT · COUNT(*) · GROUP BY
Education data levels
Student-level · Program-level · Course-level · Section-level · Enrollment-level · Attendance-level · Advising-level · Payment-level
Education Administration Tables · Data Levels · Academic/Enrollment/Attendance/Advising/Tuition Systems · Key Education Fields · Education Data Flow · Table Connections
Canonical database
education_admin_sql_course
Core Part 1 tables
students · programs · courses · sections · instructors · enrollments · attendance · tuition_payments · advising_sessions
Part 1 SQL
SELECT · DISTINCT · COUNT(*) · GROUP BY
Education data levels
Student-level · Program-level · Course-level · Section-level · Enrollment-level · Attendance-level · Advising-level · Payment-level
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
