Window Function Challenge "Find the second highest salary for each department." Customer Behavior Case "Write a query to find customers who made more than 3 purchases in the last 6 months." Retention Analysis "How would you calculate customer retention month over month?" Complex Joins Scenario "You have tables: orders, users, products. Get the top 5 users by total purchase amount in the last quarter."
Why do you want to switch. Would it be possible for you to travel to Gurgaon? The most common sql query you use. And a few general questions.
Tell us about yourself.
What is your experience in SQL?
Mainly talked about past experience shown on the resume.
And the technical one was good as well. The questions were about theoretical knowledge.
SQL queries , about projects and DBMS questions
Stupid desperate questions nothing special
An array of different SQL questions in different scenarios
Create a data model
Viewing 1211 - 1220 interview questions