Query Run
SELECT SUBSTR(log_timestamp, 1, 8) AS day, COUNT(log_id) AS Locks FROM... 1 week ago
SELECT SUBSTR(log_timestamp, 1, 8) AS day, COUNT(log_id) AS Locks FROM... 1 week ago