Measure on-time delivery by supplier country

#2 · 2 of 5Free sample

Exercises (5)

Instructions

A received purchase order is on time when received_at is on or before expected_at. For received purchase orders only, calculate the on-time rate by supplier country.

Return three columns: country_code, received_orders, and on_time_pct rounded to 1 decimal. Order by from lowest to highest, then by .

on_time_pct

country_code

Loading the practice editor and dataset…

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 →