From 7b6309d502dcf21ec079be1e585cc9d18d4ffa1d Mon Sep 17 00:00:00 2001 From: mo khan Date: Sun, 8 Mar 2020 17:11:14 -0600 Subject: Change dates --- assignments/final/run.sql | 8 ++++---- 1 file 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 -- cgit v1.2.3