Learn Practice Projects Free datasets Resources Toolkit Pricing

Log in Start free

Loading…

Hands-on analytics engineering training with browser-based practice, guided projects, and a human-reviewed capstone.

support@analyticsengineering.com

Learn

The course
Roadmap
Practice
Projects
Free datasets
Resources
Templates
Open-source toolkit
Jobs
Job market data
Guides
Glossary
Compare tools
Starting-point quiz

Topics

Analytics Engineering
SQL
dbt
Data Modeling
BigQuery
Snowflake
Looker
Python
Career
Interview Prep

Company

About
1-on-1 coaching
Pricing
Log in
Start free

© 2026 Analytics Engineering · All rights reserved

Terms Privacy Built by Routeless

Count purchase orders by status · Inventory & Supply Chain…

Home / Practice / Inventory & Supply Chain Dataset: SQL Practice

Count purchase orders by status

#1 · 1 of 5Free sample

Exercises (5)

Inventory & Supply Chain Dataset: SQL Practice

5 exercises

01Count purchase orders by statusFree
02Measure on-time delivery by supplier countryFree
03Calculate fill rate by product categoryFree
04Reconcile closing units by warehouse regionFree
05Flag stock positions below the reorder pointFree

Inventory & Supply Chain Dataset: SQL Practice

5 exercises

01Count purchase orders by statusFree
02Measure on-time delivery by supplier countryFree
03Calculate fill rate by product categoryFree
04Reconcile closing units by warehouse regionFree
05Flag stock positions below the reorder pointFree

Instructions

Procurement wants a quick status check on purchase orders.

Return two columns: status and purchase_orders. Order by purchase_orders from highest to lowest, then by status.

Loading the practice editor and dataset…

WorkspaceDraft autosaved

query.sql⌘/Ctrl + Enter

Loading editor…

Tables

7 tables · 41 columns

+

suppliers5 cols+

supplier_idTEXT PRIMARY KEY
supplier_nameTEXT NOT NULL
country_codeTEXT NOT NULL
lead_time_daysINTEGER NOT NULL
reliability_scoreREAL NOT NULL

products6 cols+

product_idTEXT PRIMARY KEY
supplier_idTEXT NOT NULL
skuTEXT NOT NULL
categoryTEXT NOT NULL
unit_costREAL NOT NULL
reorder_pointINTEGER NOT NULL

warehouses4 cols+

warehouse_idTEXT PRIMARY KEY
warehouse_nameTEXT NOT NULL
regionTEXT NOT NULL
capacity_unitsINTEGER NOT NULL

inventory_opening_balances5 cols+

opening_balance_idTEXT PRIMARY KEY
product_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
balance_dateTEXT NOT NULL
opening_unitsINTEGER NOT NULL

purchase_orders7 cols+

purchase_order_idTEXT PRIMARY KEY
supplier_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
ordered_atTEXT NOT NULL
expected_atTEXT NOT NULL
received_atTEXT
statusTEXT NOT NULL

purchase_order_lines6 cols+

purchase_order_line_idTEXT PRIMARY KEY
purchase_order_idTEXT NOT NULL
product_idTEXT NOT NULL
quantity_orderedINTEGER NOT NULL
quantity_receivedINTEGER NOT NULL
unit_costREAL NOT NULL

inventory_movements8 cols+

movement_idTEXT PRIMARY KEY
product_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
movement_atTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL
purchase_order_line_idTEXT
transfer_idTEXT

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →

jNextMeasure on-time delivery by supplier country

Tables

7 tables

suppliers5 cols+

supplier_idTEXT PRIMARY KEY
supplier_nameTEXT NOT NULL
country_codeTEXT NOT NULL
lead_time_daysINTEGER NOT NULL
reliability_scoreREAL NOT NULL

products6 cols+

product_idTEXT PRIMARY KEY
supplier_idTEXT NOT NULL
skuTEXT NOT NULL
categoryTEXT NOT NULL
unit_costREAL NOT NULL
reorder_pointINTEGER NOT NULL

warehouses4 cols+

warehouse_idTEXT PRIMARY KEY
warehouse_nameTEXT NOT NULL
regionTEXT NOT NULL
capacity_unitsINTEGER NOT NULL

inventory_opening_balances5 cols+

opening_balance_idTEXT PRIMARY KEY
product_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
balance_dateTEXT NOT NULL
opening_unitsINTEGER NOT NULL

purchase_orders7 cols+

purchase_order_idTEXT PRIMARY KEY
supplier_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
ordered_atTEXT NOT NULL
expected_atTEXT NOT NULL
received_atTEXT
statusTEXT NOT NULL

purchase_order_lines6 cols+

purchase_order_line_idTEXT PRIMARY KEY
purchase_order_idTEXT NOT NULL
product_idTEXT NOT NULL
quantity_orderedINTEGER NOT NULL
quantity_receivedINTEGER NOT NULL
unit_costREAL NOT NULL

inventory_movements8 cols+

movement_idTEXT PRIMARY KEY
product_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
movement_atTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL
purchase_order_line_idTEXT
transfer_idTEXT