MagicQOven

A Magical Oven that allows the wizards to make a magical query on Google Trends and transform that query into a beautiful graphic SELECT refresh_date AS Day, term AS Top_Term, -- These search terms are in the top 25 in the US each day. rank, FROM bigquery-public-data.google_trends.top_terms WHERE rank = 1 -- Choose only the top term each day. AND refresh_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 2 WEEK) -- Filter to the last 2 weeks. GROUP BY Day, Top_Term, rank ORDER BY Day DESC