@public #sql #mysl #date #filter #day #group #count

How to filter SQL dates by Day?

SELECT mydate, Count(mydate) FROM any_table GROUP BY DAY(mydate);