group by date MySQL timestamp

SELECT date(created_at), count(*) FROM `cal_feeds` WHERE 1 GROUP by date(created_at)  ORDER BY `date(created_at)` DESC

SELECT 
       DATE(DateJoined), 
       COUNT(UserID) AS TOT 
       FROM users 
       GROUP BY DATE(DateJoined)