Happy Reactions Production SQL query

happiest-cities.sql

WITH happy_reactions AS (
  SELECT analytics.city, analytics.country, analytics.flag, COUNT(reactions.id) AS count
  FROM analytics
  INNER JOIN reactions ON analytics.slug = reactions.slug
  WHERE reactions.reaction = 'happy' AND analytics.date >= CURRENT_DATE - INTERVAL '30' DAY
  GROUP BY analytics.city, analytics.country, analytics.flag
)
SELECT city, country, flag, count
FROM happy_reactions
ORDER BY count DESC
LIMIT 50;