Analyst
Lead Analyst
Project
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