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

Would you like to read more?