diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:41:12 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:41:12 +0000 |
| commit | c05b8c8b93e6233a1a671f5c212b7ebeacbfab3b (patch) | |
| tree | d1f19b8d480d54071cdefa85ca11f22cd31278be /wk7/pset | |
| parent | bf8d0cbdbe3f16eaa59cf25c05cbbe35a8a72cfa (diff) | |
Tue, May 21, 2024, 1:41 AM -07:00
Diffstat (limited to 'wk7/pset')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 370b13c..3770632 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -201,12 +201,12 @@ WHERE phone_number IN ( SELECT name FROM people -JOIN phone_calls ON people.phone_number = phone_calls.phone_number +JOIN phone_calls ON people.phone_number = phone_calls.caller JOIN passengers ON people.passport_number = passengers.passport_number JOIN bakery_security_logs ON people.license_plate = bakery_security_logs.license_plate -WHERE year = 2023 -AND month = 7 -AND day = 28 +WHERE phone_calls.year = 2023 +AND phone_calls.month = 7 +AND phone_calls.day = 28 AND duration <= 60 AND flight_id = ( SELECT destination_airport_id |