From 06867e8898ae888438bae43c08c1f5d04ed5e0ce Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 08:33:25 +0000
Subject: Tue, May 21, 2024, 1:33 AM -07:00

---
 wk7/pset/fiftyville/log.sql | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'wk7/pset/fiftyville/log.sql')

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
-- 
cgit v1.2.3

