PracticeExcelSign in
Google Sheets practice exercises

QUERY practice in Google Sheets

Ask a table questions in a language much like SQL: pick columns, keep the rows you want, total per group and sort, all with one formula.

Start the first exercise
  1. 1Pick columns with selectIn E1, use QUERY to show the Rep and Amount columns of A1:C6.
  2. 2Keep rows with wherePremiumIn E1, use QUERY to show the Rep and Amount of every sale over 100.
  3. 3Match text in wherePremiumIn E1, use QUERY to show the Rep and Amount of every sale in the North region.
  4. 4Totals per group with group byPremiumIn E1, use QUERY to total the Amount for each region.
  5. 5Top results with order by and limitPremiumIn E1, use QUERY to show the Rep and Amount of the two biggest sales, biggest first.

Functions in this topic