From 15ffb5d518ee74128de28665ecad4eabfa2c554a Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 07:59:56 +0000
Subject: Tue, May 21, 2024, 12:59 AM -07:00

---
 wk7/pset/fiftyville/log.sql | 31 +++++++++++++++++--------------
 1 file changed, 17 insertions(+), 14 deletions(-)

(limited to 'wk7/pset')

diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql
index 17baa56..0cf05fa 100644
--- a/wk7/pset/fiftyville/log.sql
+++ b/wk7/pset/fiftyville/log.sql
@@ -109,17 +109,20 @@ AND duration <= 60;
 .schema flights
 -- 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
-)
+-- Look for destination of flight ticket on 7/28/2023 departing from Fiftyville
+SELECT city
+FROM airports
+WHERE id = (
+    SELECT destination_airport_id
+    FROM flights
+    WHERE year = 2023
+    AND month = 8
+    AND day = 28
+    AND origin_airport_id = (
+        SELECT id
+        FROM airports
+        WHERE city = "Fiftyville"
+    )
+    ORDER BY hour
+    LIMIT 1
+);
-- 
cgit v1.2.3