根据日期获取行数

Question

This is my query that I'm using:

SELECT COUNT(*), categoryName 
FROM StuSelectCateg 
WHERE depName = 'Admisiones' timeOut>= '$Date1' 
      AND timeOut < '$Date2' 
GROUP BY categoryName

but it doesn't return any results.

This is my Database

This is the output i want but with the dates

Answer 1

Change this line

where depName = 'Admisiones' timeOut>= '$Date1' and timeOut < '$Date2'

to

where depName = 'Admisiones'  and timeOut>= '$Date1' and timeOut < '$Date2'

You are missing and before timeOut