diff options
| -rw-r--r-- | assignments/final/run.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/assignments/final/run.sql b/assignments/final/run.sql index dd20db1..2d568eb 100644 --- a/assignments/final/run.sql +++ b/assignments/final/run.sql @@ -162,11 +162,11 @@ INSERT INTO patients(id, person_id, referring_physician_id) VALUES (12, 12, 1); INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (1, 1, 10, 'heart surgery', '2020-03-01'); INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (2, 2, 11, 'knee surgery', '2020-03-02'); -INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (3, 1, 12, 'brain surgery', '2020-03-03'); -INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (4, 1, 10, 'foot surgery', '2020-03-04'); -INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (5, 1, 10, 'knee surgery', '2020-03-05'); +INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (3, 1, 12, 'brain surgery', '2020-03-02'); +INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (4, 1, 10, 'foot surgery', '2020-03-02'); +INSERT INTO treatments(id, physician_id, patient_id, name, occurred_at) VALUES (5, 1, 10, 'knee surgery', '2020-03-02'); -SELECT pe.name as physician, t.name as treatment +SELECT pe.name as physician, t.name as treatment, t.occurred_at FROM treatments t INNER JOIN physicians p on p.id = t.physician_id INNER JOIN employees e on e.id = p.employee_id |