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

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

(limited to 'wk7/pset')

diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql
index 370b13c..3770632 100644
--- a/wk7/pset/fiftyville/log.sql
+++ b/wk7/pset/fiftyville/log.sql
@@ -201,12 +201,12 @@ WHERE phone_number IN (
 
 SELECT name
 FROM people
-JOIN phone_calls ON people.phone_number = phone_calls.phone_number
+JOIN phone_calls ON people.phone_number = phone_calls.caller
 JOIN passengers ON people.passport_number = passengers.passport_number
 JOIN bakery_security_logs ON people.license_plate = bakery_security_logs.license_plate
-WHERE year = 2023
-AND month = 7
-AND day = 28
+WHERE phone_calls.year = 2023
+AND phone_calls.month = 7
+AND phone_calls.day = 28
 AND duration <= 60
 AND flight_id = (
     SELECT destination_airport_id
-- 
cgit v1.2.3