How to get the number of records for each day?

Question

SQL

Hello, tell me how to get the number of records for each period in the interval, there may be several records, or maybe 0.

Answer 1

SELECT ohm