Loading Question...
In total :8-9 ques OUT OF WHICH: 4-5 SQL queries(medium difficulty) 2-3 logical aptitude mcq 1-2 NLP basic mcq on insurance company
{Refer leetcode sql 50 for clearing this round}
Vary from interviewer to interviewer(some took for 25 mins , mine go for 50 mins) Tell me about yourself Project discussion--one of them was on analytics so she asked how did i do the data preprocessing and all
Ques 1: She gave me a query and asked to find what's wrong in this Suppose i am given a table having 2 cols Product and Monthly_sales and i want to find yearly sales Select monthly_sales*12 as annual from Products where annual>10,000;
so mistake here is you can't use alias name in the same query --you have to write montly_sales*12
10000;
Ques 2 (very famous they ask this to every candidate) https://youtu.be/xR87ctOgpAE?si=5S1B2pDwOpfBYjBQ find output of all joins--theoretically will ask the difference in all joins
Ques 3 Difference between rank,dense_rank and row_number and gave me a table customer --customer id,name,salary and asked me to find which will u use for finding the third highest salary and write the query
Ques 4 : gave me a table and output table and told me to write the query to have that output table basically it was running sum --rows_between or lead lag ques
Ques 5 she asked if i know python --but i was not proficient so i told her i'm proficient in cpp and i know the basics of python(she was going to ask me to write palindrome code in python but because i told her i'm not good she skipped this one)
Last updated Oct 15, 2026
Ques 6 gave two tables and asked me to write any Union query from this table which could produce a correct output (this ques was just to see you don't panic with the most easiest ques )
Ques 7 One guess estimate: find the number of smartphones sold in India in one year(she did n't want the ans --but explain her how do u think)
Ques 8 Puzzle: 1000 wines and 10 prisoners(GFG) Ques 9 puzzle : three bags mislabeled as apple,orange and apple +orange--fin correct labels(GFG)
Project discussion How would u rate yourself in SQL gave me one SQL query and its output and told me to write sql query for the same Sample input data id vital_name vital_value price 1 Blood pressure 128/78 200 2 Temperature 98.6 100 3 Blood pressure 120/80 200 4 Temperature 78 100 5 Blood pressure 135/85 250
output table id vital_name vital_value price 1 Systolic 128 200 1 Diastolic 78 200 2 Temperature 98.6 100 3 Systolic 120 200 3 Diastolic 80 200 4 Temperature 78 100 5 Systolic 135 250 5 Diastolic 85 250
Tips: Refere Leetcode sql 50 for clearing all round have good knowledge on cte's , window functions , basic syntax if you're not proficient in any tech stack --tell them otherwise they'll catch u anyways prepare GFG top 10 puzzles even for interview round 1 guess estimates are just for thought process --practice any 3-4 you'll have hands on