Hello All, \n\nHope you are all gearing up for your upcoming interviews. This is going to be a lengthy post so apologies for that. But I wanted to make sure I can help everyone as much as I can. These were the questions asked to me in my Phone Interview for DATA ENGINEERING role. \n\n**Overview of the Interview**\nDuration : 1 hour\nTopics : SQL, Data Warehousing and Coding (You can chose any language, I chose Python)\nQuestion Distribution : 2 questions from each topics\n\n\n**SQL Questions**\n\n*  *Given two tables  `Prodcut` and `Orders`, Can you find out which Product was sold the most in the year 2020?*\n*  *For the below dataset :*\n\n    ![image](https://assets.leetcode.com/users/images/3b97720f-f486-4600-b6f9-4562a82b2bb4_1610676725.2342455.png)\n\t\n\t*Write a Query to generate the output as below without using window functions:*\n\t\n\t![image](https://assets.leetcode.com/users/images/a26d33a9-9deb-4e11-955c-33280d0d04fb_1610676874.6447275.png)\n\t\n**Data Warehousing Questions**\n\n* *For the 1st query, how many times do you think the Orders table would be scanned? And partitioning the table help improving performance?\n What are the pros & cons of using AWS Redshift over other DataWarehousing solutions (Oracle, MySQL, etc)*\n\n**Coding Questions**\n\n*  *Given a list of numbers `[1,2,3,4,5,6,7,8,9]`, print all the pairs for which the summation of index positions is equal to 10*\n*  *Given a list of words, can you find out the frequency of each word?*\n\n\nI hope this helps anyone who has an interview coming up. All the very best!\n\n\n

Hello All, \n\nHope you are all gearing up for your upcoming interviews. This is going to be a lengthy post so apologies for that. But I wanted to make sure I c

Amazon Data Engineering - Phone Interview Questions