1 files changed, 14 insertions, 1 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql
index e383ef4..17baa56 100644
--- a/wk7/pset/fiftyville/log.sql
+++ b/wk7/pset/fiftyville/log.sql
@@ -107,6 +107,19 @@ AND duration <= 60;
 
 -- What data does flights have
 .schema flights
--- origin, destination,
+-- origin, destination
+
+-- What id is the Fiftyville airport?
+
 
 -- Look for purchase of flight ticket on 7/28/2023 after 10:15 departing from Fiftyville
+SELECT destination_airport_id, id
+FROM bakery_security_logs
+WHERE year = 2023
+AND month = 7
+AND day = 28
+AND hour = 10
+AND minute >= 15
+AND origin_airport_id = (
+    SELECT
+)