Amazon Data Engineer I interview questions

The below questions were asked. 3 tables are there with many to many relationship (Order and Item) Order table (OrderId, OrderDate) Item Table (ItemId, Name) Order Item table (OrderId, ItemId) Find all customers who purchased items - Kindle and Alexa both (Exclude customers who purchased only 1 item) Find the items in the first purchase for a customer - Print customer id, item id Delete duplicate rows from the Order table

Biggest Challenge