Amazon Business Intelligence Engineer interview questions

The next round was a technical phone interview. The interviewer was a senior BIE and focused primarily on assessing my SQL and data analysis skills. The questions included: SQL: Write a query to find the second highest salary in a table of employee data. Data Analysis: Explain how you would go about analyzing a dataset of sales transactions to find trends, anomalies, and correlations. Business Problem Solving: How would you approach solving a problem where the business needs to understand customer retention and lifetime value using available data?