Count results of table by date
Are there any transactions on that particular day?
Check the data &quot;by eye&quot; and see if it's the query that's &quot;missing&quot; them or if they really aren't there at all!
Your query looks OK to me.
Your table I'm less convinced about.
Having a table called &quot;table&quot; is a Bad Idea.
Using any reserved word as an identifier (table, column, anything else) is likely to come back and bite you at some point.  Save yourself the trouble; you should never need to &quot;protect&quot; the identifiers in your SQL.
What Data Type are you using for the start_time column?
I'm hoping it's a Date-related one but, given the problem you're having, I'm guessing it's not and that the values stored in it are in a different &quot;format&quot;.
For example:
select top 5 * 
from table1 ; 

+--------+-----------------------+
| seq_no | start_time_as_varchar |
+--------+-----------------------+
|    111 | 25-Apr-2021 00:00:01  |
|    222 | 26-Apr-2021 00:00:01  |
|    333 | 27-Apr-2021 00:00:01  |
|    444 | 28/04/2021 00:00:01   |
|    555 | 2021-04-29 00:00:01   |
+--------+-----------------------+

The values are perfectly valid Character Representations of date values, but they're not held in [a column with] a Date Data Type, so SQL Server will do a character-by-character comparison, not a date-wise comparison.
Always store Date Values in Date[-related] Data Types.