Key Education Fields

Overview

Education analysis depends on a set of key fields that connect data across tables and help track students, courses, and administrative processes.

• student_id — identifies each student in the students table and links to enrollments, attendance, advising, and tuition records.
• program_id — identifies academic programs and connects students to their program of study.
• course_id — identifies courses and links them to sections and departments.
• section_id —identifies specific course offerings and connects courses, instructors, and enrollments.
• term_id —identifies academic terms and allows analysis across semesters or academic years.
• instructor_id — identifies faculty members and links them to teaching assignments and sections.
• payment_status — describes whether tuition is paid, partially paid, or outstanding.
• enrollment_status — shows whether a student is enrolled, withdrawn, or completed a course.

These fields are essential because they allow you to track student progression, course delivery, teaching assignments, and financial activity across the institution.

---

The Basic Pattern

SELECT column_name, COUNT(*) AS total
FROM table_name
GROUP BY column_name;
  

---

Examples

Example 1 — Count Students by Program

Example 2 — Count Sections by Term

Example 3 — Count Enrollments by Status

---

Practice Tasks (Your Turn!)

Task 1

Count the number of payments by payment status.

Task 2

Count the number of instructors by department.

Task 3

Count the number of enrollments by section.