diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:33:25 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:33:25 +0000 |
| commit | 06867e8898ae888438bae43c08c1f5d04ed5e0ce (patch) | |
| tree | f02fe68112c3177831c5c03f5d57fe5c4020db7e /wk7/pset/fiftyville/log.sql | |
| parent | 4314c255a92d5f9f0619127e720977f1102e498a (diff) | |
Tue, May 21, 2024, 1:33 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville/log.sql')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 81fedda..e40cba9 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -135,7 +135,8 @@ WHERE id = ( -- Check passport numbers and seats of passengers on flight with id of 36 SELECT passport_number, seat FROM passengers -WHERE flight_id = (SELECT destination_airport_id +WHERE flight_id = ( + SELECT destination_airport_id FROM flights WHERE year = 2023 AND month = 7 @@ -198,6 +199,12 @@ WHERE phone_number IN ( ) ; +SELECT name +FROM people +JOIN phone ON people.phone_number = phone.phone_number +JOIN phone ON people.phone_number = phone.phone_number +JOIN phone ON people.phone_number = phone.phone_number + SELECT name FROM people |