diff options
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; |