SELECT date_trunc('month', rated_at)::date AS month, gender, COUNT(*) FROM ratings INNER JOIN users ON ratings.user_id = users.id GROUP BY month, gender ORDER BY month, gender
Run Cancel
Part of 1 dashboard. Be careful when editing.

Loading...