... UserID and identified as staff or student.
Number of total hits aggregated by month with on-peak/off-peak.
SELECT
CONCAT(MONTHNAME(a.DateTimeStamp), ' ', YEAR(a.DateTimeStamp)) Month,
SUM(IF((HOUR(a.DateTimeStamp) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.