QUERY practice

QUERY runs a SQL-like query over a range, with select, where, group by, order by and limit, in Google Sheets. Below are the 3 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

QUERY(data, query, [headers])

What people get wrong

Columns are named by letter inside the query text, and text values need single quotes: where B = 'North'.

Google Sheets exercises that use QUERY

• QUERY for a totalLevel 4Pro
• Top region with QUERYLevel 4Pro
• Count with QUERYLevel 4Pro

Often used together with: INDEX