Filtering Academic and Administrative Records with WHERE Conditions

Overview

In education administration, not all data is needed at once. The WHERE clause allows you to filter records and focus only on specific students, courses, enrollments, or administrative data.

Filtering is important when you want to answer targeted questions such as:
• Which students are currently active?
• Which enrollments are completed?
• Which payments are outstanding?

The WHERE clause works by applying conditions to columns, returning only the rows that meet those conditions.

Common uses of WHERE include:
• Filtering by status (e.g., Active, Completed)
• Filtering by dates (e.g., admission or enrollment dates)
• Filtering by specific values (e.g., program, course, instructor)

---

The Basic Pattern

SELECT column1, column2
FROM table_name
WHERE condition;
  

---

Examples

Example 1 — Retrieve Active Students

Example 2 — Retrieve Completed Enrollments

Example 3 — Retrieve Outstanding Tuition Payments

---

Practice Tasks (Your Turn!)

Task 1

Retrieve courses that are at the undergraduate level.

Task 2

Retrieve sections that are delivered online.

Task 3

Retrieve advising sessions that require follow-up.