diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 07:40:38 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 07:40:38 +0000 |
| commit | 7eaf21f77fb6351e10ac8b859c390fb3abe2918d (patch) | |
| tree | 1ad79c58361096d452c1fba0660692354c22899c /wk7/pset | |
| parent | 5e3da4ab87a795d54c196aff6316040648261231 (diff) | |
Tue, May 21, 2024, 12:40 AM -07:00
Diffstat (limited to 'wk7/pset')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 8 |
1 files changed, 7 insertions, 1 deletions
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; |