diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 07:51:27 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 07:51:27 +0000 |
| commit | 5c242fed39719f02c7b1c30b168058b4e599102e (patch) | |
| tree | 25d1d246fda0759500c62969a08e4e7ff651dec4 /wk7/pset/fiftyville | |
| parent | 9523f108fb86970442652ec9477cf8564e3d20de (diff) | |
Tue, May 21, 2024, 12:51 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 15 |
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 +) |