Loading this exercise…

Reconcile inventory closing balances

#4 · 4 of 5Free sample

Instructions

Reconcile inventory closing balances

An operations team needs to reconcile closing inventory from inventory_opening and inventory_movements. Closing units equal opening_units plus every signed quantity_change. Preserve products that have no movements.

Return exactly two columns: product_id and closing_units. Return one row per product, ordered by product_id.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

A free account records your attempt and then reveals the reference answer and the explanation for every exercise in the library.

Reference answer + explanation revealed after each attempt
Progress saved on the platform
1,598 graded exercises
Free forever — no credit card
The GPT tutor is part of the course, not the free tier

Create free account →Already a member? Log in →

All exercises in Free Dataset Analysis

6 cols

order_idINTEGER PRIMARY KEY
customer_idINTEGER NOT NULL
order_dateTEXT NOT NULL
statusTEXT NOT NULL
gross_amountREAL NOT NULL
discount_amountREAL NOT NULL

ecommerce_refunds4 cols

refund_idINTEGER PRIMARY KEY
order_idINTEGER NOT NULL
refund_dateTEXT NOT NULL
refund_amountREAL NOT NULL

subscription_accounts2 cols

account_idINTEGER PRIMARY KEY
started_onTEXT NOT NULL

subscription_events5 cols

event_idINTEGER PRIMARY KEY
account_idINTEGER NOT NULL
event_dateTEXT NOT NULL
event_typeTEXT NOT NULL
plan_mrrREAL NOT NULL

campaign_imports6 cols

import_idINTEGER PRIMARY KEY
campaign_idTEXT
activity_dateTEXT NOT NULL
channelTEXT NOT NULL
spend_usdREAL NOT NULL
conversionsINTEGER NOT NULL

inventory_opening2 cols

product_idINTEGER PRIMARY KEY
opening_unitsINTEGER NOT NULL

inventory_movements5 cols

movement_idINTEGER PRIMARY KEY
product_idINTEGER NOT NULL
movement_dateTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL

bike_hourly6 cols

observation_idINTEGER PRIMARY KEY
ride_dateTEXT NOT NULL
hourINTEGER NOT NULL
working_dayINTEGER NOT NULL
seasonTEXT NOT NULL
rentalsINTEGER NOT NULL

Tables

8 tables

ecommerce_orders6 cols

order_idINTEGER PRIMARY KEY
customer_idINTEGER NOT NULL
order_dateTEXT NOT NULL
statusTEXT NOT NULL
gross_amountREAL NOT NULL
discount_amountREAL NOT NULL