SQL workspace

Works like a database query tool, with PostgreSQL rules. Answer six questions from the head of analytics with joins, groups, windows and CTEs.

Data desk

Lakeshore Family Health0 of 6 answered

QuickCruit SQL

-- Ctrl or Cmd + Enter runs the query the cursor is in.
-- Click a table or column on the left to type its name.
SELECT *
FROM orders
LIMIT 20;

-- Ctrl or Cmd + Enter runs the query the cursor is in.
-- Click a table or column on the left to type its name.
SELECT *
FROM orders
LIMIT 20;

Results show up here. Run a query to start, or click a table name in the explorer to put it in the editor.

Connected

Ready

Need six figures for the half-year business review, January through June. They go on the slides Friday.

Source is the orders database, read-only: customers, orders, order_items and products. Definitions are in each question below.

Any SQL that returns the right rows works. I don't care about column names, only the numbers. Check each one before you move to the next.

Lakeshore Family Health is a made-up company. A practice scenario, built for you.

0 of 6 answered

How many different customers ordered in each month? One row per month, oldest first: the month and the count.
Run a query first.

Checking is free and as often as you like. Your queries stay in the editor and in History.