Identifying Active Students, Full Sections, Multi-Course Enrollments, and Instructor Teaching Loads

Overview

In education administration, identifying key patterns helps support decision-making. This includes finding active students, detecting full or near-capacity sections, identifying students enrolled in multiple courses, and understanding instructor workloads.

The students table helps identify active students using the student_status field.

The sections table allows you to evaluate capacity using max_capacity.

The enrollments table shows how many courses a student is taking.

The teaching_assignments table helps measure how many sections each instructor is teaching.

These insights are useful for managing enrollment, balancing class sizes, and allocating teaching resources.

---

The Basic Pattern

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

---

Examples

Example 1 — Identify Active Students

Example 2 — Identify Students Enrolled in Multiple Sections

Example 3 — Identify Instructor Teaching Load

---

Practice Tasks (Your Turn!)

Task 1

Identify Sections with 2 or More Enrollments

Task 2

Identify students who are currently inactive.

Task 3

Identify instructors who teach more than one section.