Sql-Questions-Practice

Problems

1. Recyclable and Low Fat Products
2. Find Total Time Spent by Each Employee
3. Number of Unique Subjects Taught by Each Teacher
4. Daily Leads and Partners
5. Invalid Tweets
6. Capital Gain/Loss
7. Replace Employee ID With The Unique Identifier
8. Rearrange Products Table
9. Bank Account Summary II
10. Swap Salary
11. Product Sales Analysis I
12. Reformat Department Table
13. Customer Who Visited but Did Not Make Any Transactions
14. Group Sold Products By The Date
15. The Latest Login in 2020
16. Find Customer Referee
17. Rising Temperature
18. Managers with at Least 5 Direct Reports
19. Not Boring Movies
20. Average Selling Price
21. Project Employees I
22. User Activity for the Past 30 Days I
23. Product Sales Analysis III
24. The Number of Employees Which Report to Each Employee
25. Primary Department for Each Employee
26. Consecutive Numbers
27. Fix Names in a Table
28. Big Countries
29. Average Time of Process per Machine
30. Confirmation Rate
31. Monthly Transactions I
32. Percentage of Users Attended a Contest
33. Classes More Than 5 Students
34. Find Followers Count
35. Customers Who Bought All Products
36. Triangle Judgement
37. Product Price at a Given Date
38. Article Views I
39. Employee Bonus
40. Immediate Food Delivery II
41. Biggest Single Number
42. Last Person to Fit in the Bus
43. Students and Examinations
44. Queries Quality and Percentage
45. Game Play Analysis IV
46. Count Salary Categories
47. Employees Whose Manager Left the Company
48. Exchange Seats
49. Movie Rating
50. Restaurant Growth
51. Find Users With Valid E-Mails
52. List the Products Ordered in a Period
53. Department Top Three Salaries