They started with an SQL question, which was easy. The next question required using window functions. Query tuning questions followed.

Then, the interviewer began asking data modeling questions, which I did not expect. My recruiter had stated it would be a SQL and Python Data Structure interview, but there were no Python DS questions.

SQL.

We have a table below:

Team

India England Srilanka

Can you write a SQL code to generate all possible combinations between the above input teams?

We have the following dataset:

Employee_salary Snapshotdate | 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 their current and immediate previous salary. b) Identify employees based on the highest salary increase from their first salary, who joined more than 2 years ago. c) Identify employees where the salary increase between the last two years is more compared to the average salary increase in the last two years.