Daily Net Inventory Movement

Problem

A warehouse logs how many units moved in and out of stock each day.

Table: `Movements`

```text
+-----------+---------+
| Column | Type |
+-----------+---------+
| move_day | date |
| direction | varchar |
| units | int |
+-----------+---------+
(move_day, direction) is the primary key.
direction is either 'inbound' or 'outbound'.
Each row gives the total number of units moved in that direction on that day.
```

For each day, report the net change in stock, defined as inbound units minus outbound units. Name the column `net_change` and order the result by `move_day`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns move_day, net_change.

Starter code (SQL)

SELECT *
FROM Movements;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium