Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer
Task 138:

Order Statuses by Customer Country

Firebird
For every customer country and every order status found in the sales table, count the orders of the customers from that country with that status. A country–status pair without orders must be shown with 0.
Output columns:
- country - the customer's country
- order_status - the order status
- orders - the number of orders

Sort the result by country, then by order_status.
Expected result Columns: 3 · Rows: 33
COUNTRY ORDER_STATUS ORDERS

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial
The query result will appear here. Ctrl+Enter - Run query