Position: Data Engineer\n\nI feel there is not much information out there for amazon DE interviews , So wanted to give back to the community. I recently had interview with Amazon  for DE roleand I was asked these SQL questions\n\nLets say if we have streaming and content tables as below:\n```sql\nSTREAMS\nStream_date  Customer_id  Content_ID   Marketplace_ID   device_type\n2012-02-01   12345        SRT123          US             ipad     \n2012-02-01   67890        SRT123          UK             TV\n2012-02-01   98765        XYZ123          US             iphone\n\nContent\nContent_ID    KIDS_CONTENT       Content_type\nSRT123           Y                series\nXYZ123           N                movie\nABC123           Y                movie\n```\n\n1. Write a query to get the number of unique kid friendly titles that were streamed last month\n\n2. Customers who watched kids friendly movie but never watched any Series\n\n3. Write a query to get a list of all customers who watched at least a one kid friendly movie every week in last 3 months\n\n\nHope this helps the community!

Position: Data Engineer\n\nI feel there is not much information out there for amazon DE interviews , So wanted to give back to the community. I recently had int