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

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

(limited to 'wk7/pset')

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;
-- 
cgit v1.2.3