From 7eaf21f77fb6351e10ac8b859c390fb3abe2918d Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 07:40:38 +0000
Subject: Tue, May 21, 2024, 12:40 AM -07:00

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

(limited to 'wk7/pset')

diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql
index dfe36ee..f251a88 100644
--- a/wk7/pset/fiftyville/log.sql
+++ b/wk7/pset/fiftyville/log.sql
@@ -86,4 +86,10 @@ AND transaction_type = "withdraw";
 .schema phone_calls
 -- caller, reciever, duration, date
 
--- Check for call on 7/28/2023
+-- Check for call on 7/28/2023 and duration of less than 1 minute | caller is thief, reciever is accomplice
+SELECT duration, caller, receiver
+FROM phone_calls
+WHERE year = 2023
+AND month = 7
+AND day = 28
+AND duration <= 60;
-- 
cgit v1.2.3