From a1cb4c0e8c149480b34202574808ceff8e568fc7 Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Tue, 21 May 2024 08:05:48 +0000 Subject: Tue, May 21, 2024, 1:05 AM -07:00 --- wk7/pset/fiftyville/log.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'wk7/pset/fiftyville/log.sql') 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 -- cgit v1.2.3