Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
27. Patient Appointment No-Shows
On this page

Problem

Table: Appointments

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| appointment_id | int     |
| patient_id     | int     |
| doctor_id      | int     |
| appointment_date | date  |
| status         | enum    |
+----------------+---------+
appointment_id is the primary key (column with unique values) for this table.
patient_id is the ID of the patient who has the appointment.
doctor_id is the ID of the doctor with whom the appointment is booked.
appointment_date is the date when the appointment is scheduled.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page