diff options
Diffstat (limited to 'wk7/pset/fiftyville')
| -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 |