Sample prompt:

I have Search Console data stored in SQL table searchconsole.searchdata_site_impression. It has the following fields:

• data_date DATE NULLABLE
• site_url STRING NULLABLE
• query STRING NULLABLE
• anonymized_query BOOLEAN NULLABLE
• country STRING NULLABLE
• search_type STRING NULLABLE
• device STRING NULLABLE
• impressions INTEGER NULLABLE
• clicks INTEGER NULLABLE
• sum_top_position INTEGER NULLABLE

I want to see countries with highest number of clicks. Add information about impressions to the final table.

Sample output:

SELECT country, SUM(clicks) AS total_clicks, SUM(impressions) AS total_impressions FROM searchconsole.searchdata_site_impression GROUP BY country ORDER BY total_clicks DESC