diff options
| author | mo khan <mo.khan@gmail.com> | 2020-03-08 17:11:14 -0600 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-03-08 17:11:14 -0600 |
| commit | 7b6309d502dcf21ec079be1e585cc9d18d4ffa1d (patch) | |
| tree | d875366c847922ad18453f49be5a416ea8945133 /assignments/final/run.sql | |
| parent | 1d067eaead2a59dbbdad216738d3e874aac9f137 (diff) | |
Change dates
Diffstat (limited to 'assignments/final/run.sql')
| -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 |