Hi! I was trying to get the timeseries of new user registrations in wikipedia, by day (two columns, day and count), but my query is really slow. Am I doing something wrong?
SELECT DATE(user_registration) AS registration_date, COUNT(*) AS user_count FROM user WHERE user_editcount > 10 GROUP BY DATE(user_registration) ORDER BY registration_date;