fbpx

69. Inventory Stock Calculation

This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
 

Given the following Products table in Helen’s Pastry Shop. This table holds the information of pastries Helen made and sold every day. For example, on January 1st, at 08:00 AM, Helen made 50 new units of product no. 1, and sold 20 units.


CREATE TABLE stock
(stock_id int identity(1,1),
stock_datedatetime,
product_id int,
stock_in int,
stock_out int)
GO

To read more

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…