/ Published in: SQL
grouping using between and date
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT DATE(CreatedAt), COUNT(*) FROM gamma_wimbledon WHERE (Latitude BETWEEN '51.42361745514588' AND'51.44261323389316') AND (Longitude BETWEEN '-0.2270221710205078' AND '-0.19196033477783203') GROUP BY DATE(CreatedAt);