Amazon Data Engineer interview questions

SQL. We have a table below : Team ------ India England Srilanka Can you write a SQL code, by which we can generate all possible combinations between the above input teams? We have the below dataset : Employee_salary Sanpshotdate | Employee | Doj | Current Salary -------------------------------------------------------- 01-Jan-2022 | 1 | 01-Jan-2021 | 1000 01-Jan-2023 | 1 | 01-Jan-2021 | 2000 01-Jan-2024 | 1 | 01-Jan-2021 | 2300 01-Jan-2025 | 1 | 01-Jan-2021 | 3000 a) Print for each employee what was current and immediate previous salary b) Identify the employees based on the highest increase of salary from the first salary, who have joined more than 2 years ago c) Identify the employees where salary increase between the last two years are more compared to the average salary increase in the last two years