Line Chart Format 2

Edit Fork
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

Loading...