diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:05:48 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:05:48 +0000 |
| commit | a1cb4c0e8c149480b34202574808ceff8e568fc7 (patch) | |
| tree | 354bca765385b20f70005c8f0deba8b3be958e24 /wk7/pset/fiftyville/log.sql | |
| parent | 15ffb5d518ee74128de28665ecad4eabfa2c554a (diff) | |
Tue, May 21, 2024, 1:05 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville/log.sql')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 0cf05fa..894fb2c 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -116,8 +116,8 @@ WHERE id = ( SELECT destination_airport_id FROM flights WHERE year = 2023 - AND month = 8 - AND day = 28 + AND month = 7 + AND day = 29 AND origin_airport_id = ( SELECT id FROM airports @@ -126,3 +126,6 @@ WHERE id = ( ORDER BY hour LIMIT 1 ); +-- Destination City is New York City + +-- Check passengers on flight with id of 36 |