T23 SQL query on SQLite

Category: Code / data. Pass at 3/3.

All 40 tasks

Prompt

Using shop.db (SQLite), write a SQL query for the top 3 customers from NL by total order value in August and September 2026. Give the query and the result.

Inputs

Files attached to the chat:

• shop.db

Checklist

Pass at 3/3.

• Result matches the answer key (names and totals)
• The query runs on shop.db
• Date filter right (August and September 2026)

The answer key is not published while the task set is in use.