27. Patient Appointment No-Shows

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Table of Contents

Contents are not accessible

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!

Table of Contents

Contents are not accessible