Q 1. Explain 1st,2nd and 3rd Normal form ?

Q 2. How to find employees whose salary is in the top 10%?

Q 3. Write a query to get employees who belong to departments with less than 3 employees.

Q 4. What is the size of Char vs NChar?

Q 5. Write a query to display employees grouped by their age brackets

Q 6. Differentiate between After trigger vs Instead of?

Q 7. How to find all employees who are older than 30 years?

Q .8How to write a query to delete employees who have been in the company for more than 15 years?

Q 9. Write a query to list all employees working under the same manager.

Q10. Explain indexes , how does it make search faster?

Q11. Write a query to display the hire date and day of the week for each employee.

Q12. Write a query to list all employees with more than 5 years of experience in each department.

Q13. Write a query to find all employees who earn more than the average salary of their department .

Q14. How to list all managers who have more than 5 subordinates?

Q15. Write a query to display employee names and hire dates in the format “NAME-MM /DD / YYYY”.

Q16. How to list all employees who do not have a bonus?

Q17. How to find employees whose salary is higher than their manager’s salary?

Q18. How to find the average salary of the top 5 highest_paid employees in each department ?

Q19. How to calculate the percentage of employees in each department ?

Q20. What is the need of Identity?

Q21. How to list all employees in departments that have not hired anyone in the past 2 years?

Q22. How to write a query to find employees with the same first name?

Q23. Write a query to display employees grouped by their salary range.

Q24. Write a query to display the highest, lowest, and average salary for each job role.

Q25. How to find the top 3 highest-paid employees in each department?

Q26. Write a query to find all employees whose email contains the domain ‘@example.com’.

Q27. How to retrieve the year-to -date sales for each customer ?