Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Lead Analyst

Project

Find the Impossible Stock

Meridian Retail Co. · SQL · beginner

The brief

Shelves are empty and the system says we are selling stock we do not have. Ground-level check: the inventory table has a stock_qty column, and stock should never be below zero. List every inventory row where stock_qty is negative, showing the product_id, store_id and stock_qty, with the worst (most negative) first. Also tell me how many such rows there are.

Independent grading

98/100

Achieved 5 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more