9. Same-Day Appointment Fulfillment (Medium)

Problem Statement

Table: Appointments
This table holds information about medical appointments for patients. Each appointment includes an appointment ID, patient ID, the date the appointment was made, and the preferred appointment date specified by the patient.

+------------------------+---------+
| Column Name            | Type    |
+------------------------+---------+
| appointment_id         | int     |
| patient_id             | int     |
| booking_date           | date    |
| patient_pref_date      | date    |
+------------------------+---------+