From 5c242fed39719f02c7b1c30b168058b4e599102e Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 07:51:27 +0000
Subject: Tue, May 21, 2024, 12:51 AM -07:00

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

(limited to 'wk7/pset')

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