79 ) sql queries to write

 

SQL Queries for Common Interview Problems

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
All Questions : 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

1)  find the 4th highest salary from an Employee table.
2) Delete Duplicate Records
3) Find Each Department wise - Highest Salary of employees
4) Count Number of Subjects per Student (Comma-Separated Data)
5) SSMS - Cumulative Salary of Each Employee by Department
6) Customers Purchasing the Same Product in Different Stores in Same Month
7) Most Sold Product by Each State
8) Department-Wise Sum of Salaries and Max Salary
9 ) query to find the customer who ordered more than 5 orders 
 
10 ) customers historical addresses  
11. emps  salary is greater than their manager 
12 .  show team  size of  each employee in the query result 

14 )  Query to find duplicate rows of loan id but time is different 
15 )   Find out  ( all sessions ,durations ) of a user in  a portal 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
16  ) SQL concept based qsns

Constraints in sql ( 8) ✅
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~