<invoke name="query_sql"> <parameter name="sql">SELECT YEAR, COUNT(*) AS pages, COUNT(DISTINCT WEBSITE) AS websites, SUM("PAGE VIEWS") AS page_views, SUM("UNIQUE VIEWS") AS unique_views, SUM(ENTRANCES) AS entrances, AVG("BOUNCE RATE (%)") AS avg_bounce, AVG("EXIT RATE (%)") AS avg_exit, AVG("AVERAGE TIME ON PAGE (SECONDS)") AS avg_time_on_page FROM raw.Website_Analytics GROUP BY YEAR ORDER BY YEAR</parameter> <parameter name="purpose">Yearly trend of traffic measures</parameter> <parameter name="source">raw</parameter> </invoke> ``` <invoke name="think"> <parameter name="reasoning">Waiting for result.</parameter> </invoke>