Pergunta de entrevista da empresa Amazon
Q2 What items were ordered yesterday but not ordered today? Output: item_id
Resposta da entrevista
Sigiloso
18 de set. de 2020
0 ▼ Select distinct s1.Product_Id From Sales s1 Where s1.Sales_Date = DateAdd(day, -1, cast(getdate() as date)) --ordered yesterday and Not Exists (Select 1 From Sales s2 Where s1.product_id = s2.product_id and s2.SALES_DATE = cast(getdate() as date)) --but were not ordered today
1