Find the hours for which the product ‘A’ was out of stock, assuming this is all the data for one day only

Question

Product_inv

Product ID   is_in_stock create_dt
A   1 2019-01-01 0:00
A   0 2019-01-01 10:00
A   1 2019-01-01 13:00
A   0 2019-01-01 20:00
A   1 2019-01-01 23:59

 

Find the hours for which the product ‘A’ was out of stock, assuming this is all the data for one day only?

0
vinod.k 4 days 0 Answers 12 views Newbie 0

Leave an answer

Browse
Browse