diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 07:12:07 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 07:12:07 +0000 |
| commit | f5705af465b4d01050c3a47e9204e427b8b0c9fd (patch) | |
| tree | 3942f5eaf90b8562fb6fbe49b895440cb672ec2b /wk7/pset/fiftyville/log.sql | |
| parent | e049826b0ba952306e121f886ceb7a359969e02e (diff) | |
Tue, May 21, 2024, 12:12 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville/log.sql')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 1ac3197..1dd5dbb 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -50,3 +50,11 @@ AND transcript LIKE "%bakery%"; .schema bakery_security_logs -- Check activity and license plate of bakery cams on 7/28/2023 from 10:05 to 10:25 +SELECT activity, license_plate +FROM bakery_security_logs +WHERE year = 2023 +AND month = 7 +AND day = 28 +AND hour = 10 +AND minute >= 5 +AND minute <= 25; |