Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

9. Same-Day Appointment Fulfillment (Medium)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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    |
+------------------------+---------+

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible