SELECT 
  YEAR(ratings_t."date") AS "year", 
  "household_rating" AS "rating", 
  "cost_of_30_second_ad_usd" AS "cost per 30s (nominal)", 
  COUNT(*) FILTER (WHERE "use_sex") AS "sexy", 
  COUNT(*) FILTER (WHERE "patriotic") AS "patriotic", 
  COUNT(*) FILTER (WHERE "funny") AS "funny",
  COUNT(*) FILTER (WHERE "celebrity") AS "celebrity",
  COUNT(*) FILTER (WHERE "animals") AS "animals"
FROM @kaggle.mattop_super_bowl_television_ratings.super_bowl_ratings ratings_t
LEFT JOIN @kaggle.thedevastator_uncover_america_s_secrets_through_super_bowl_ads.superbowl_ads ads_t
  ON YEAR(ratings_t."date") = ads_t."year"
WHERE "year" BETWEEN 2000 AND 2020
GROUP BY 
  YEAR(ratings_t."date"), 
  "household_rating", 
  "cost_of_30_second_ad_usd"
ORDER BY "year"