Weekly Inventory Turns SQL | Dataford Interview Questions

Write a SQL query to analyze weekly inventory turns by product category and identify the categories with the largest week-over-week decline for Fashion Nova.

Use the provided product, weekly inventory, and weekly sales data. Treat missing weekly sales as zero and return the three largest percentage declines.

Output

One row per category-week decline, limited to the three largest percentage declines.
Columns: category, week_start, prior_week_turns, current_week_turns, decline_turns, and decline_pct.
Sort by decline_pct descending, then category ascending and week_start descending for ties.

Schema

products

Column	Type	Description
product_idPK	INT	Unique product identifier
sku	VARCHAR(30)	Fashion Nova stock keeping unit
product_name	VARCHAR(100)	Product display name
category	VARCHAR(50)	Product category

weekly_inventory

Column	Type	Description
inventory_idPK	INT	Unique weekly inventory record
product_id	INT	Referenced product
week_start	DATE	Monday starting the reporting week
beginning_inventory	INT	Units available at the start of the week
ending_inventory	INT	Units available at the end of the week

weekly_sales

Column	Type	Description
sales_idPK	INT	Unique weekly sales record
product_id	INT	Referenced product
week_start	DATE	Monday starting the reporting week
units_sold	INT	Units sold during the week

Your question is Weekly Inventory Turns SQL. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem