Query Run
SELECT DATE(user_registration) AS registration_date, COUNT(*) AS... 6 months ago
SELECT DATE_FORMAT(user.user_registration, '%Y-%m-%d') AS date, COUNT(*) as... 6 months ago