Copy This SQL

#standardSQL
SELECT block, count(*) as count from `bigquery-public-data.chicago_crime.crime`
where DATE(date) > DATE_SUB(CURRENT_DATE(), INTERVAL 14 DAY)
group by block
order by count DESC
limit 10;
Copy SQL
Why should I do this?
Cirkulate uses SQL to fetch data from databases so that you dont have to copy-paste from SQL output or write code to automate this process of setting data in a spreadsheet.

In the next step, you will use our dummy database to populate a spreadsheet using this SQL.

For now, just copy the SQL so that you can paste it into the query editor in the next step.