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

Loading...