Today I had my phone screen interview with Amazon for Sr Data engineer role
It was coding round

Interviewer explain about coding round then his introduction
He asked me about my intro and my day2day responsibility in current project.

Coding:-
given two table
Purchase_table
purchase_id,cust_id,device_id,quantity,purchase_Date

deivece_Table
Device_id, Device_name
10 , iphone
20, ipad
30, imac
40, iwatch

Q1 customer who bought iphone but never bought ipad
Q2 customer who bought iphone but never bought ipad before iphone
Q3 top 3 seeling product for each month
Q4 Dont remember question but easy one by using left join and some filter question

Q5- use any programming language
date , series
2022-01-01 Friends
2022-02-01 Friends
2022-03-01 Friends
2022-04-01 Friends
2022-05-01 Friends
2022-06-01 Friends
2022-07-01 Friends
2022-08-01 Friends
2022-01-01 Breaker
2022-02-01 Breaker
2022-03-01 Breaker
2022-04-01 Breaker
2022-07-01 Breaker
2022-08-01 Breaker

o/p
series, start_Date,end_date
Friends, 2022-01-01, null
Breaker, 2022-01-01,2022-04-01
Breaker, 2022-07-01,null

I really dont know what was the reason of rejction coz i write query for first 4 question and correct one coz each and every step i was doing i explained with data only for 5th question i was having only 3 min left so i read question and gave him logic :(