SQL Practice Logo

SQLPractice Online

Company SQL Question

Product Replenishment Priority Analysis

Practice this Amazon style SQL interview question with live execution and instant feedback.

Problem Statement

Identify the top 5 stockout-risk products using a CTE for sales velocity and a window function for priority ranking.

Relevant Tables

productswarehousesorder_items

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: