SQL Practice Questions (100 Questions)

Q01. List all unique job roles from the EMP table.

Q02. Display all employee names that start with 'S'.

Q03. Show employees with salary between 1000 and 3000.

Q04. Find distinct department numbers from EMP.

Q05. List employees who do not belong to department 10.

Q06. Show job titles having more than 2 employees.

Q07. List employees whose name does not start with 'A', 'J', or 'S'.

Q08. Display all employee names ending with 'N'.

Q09. Show the maximum salary in each department.

Q10. Find the total number of employees for each job role.

Q11. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q12. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q13. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q14. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q15. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q16. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q17. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q18. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q19. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q20. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q21. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q22. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q23. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q24. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q25. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q26. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q27. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q28. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q29. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q30. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q31. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q32. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q33. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q34. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q35. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q36. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q37. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q38. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q39. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q40. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q41. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q42. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q43. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q44. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q45. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q46. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q47. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q48. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q49. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q50. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q51. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q52. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q53. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q54. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q55. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q56. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q57. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q58. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q59. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q60. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q61. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q62. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q63. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q64. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q65. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q66. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q67. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q68. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q69. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q70. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q71. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q72. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q73. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q74. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q75. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q76. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q77. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q78. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q79. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q80. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q81. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q82. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q83. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q84. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q85. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q86. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q87. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q88. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q89. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q90. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q91. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q92. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q93. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q94. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q95. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q96. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,
GROUP BY, or HAVING.

Q97. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q98. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q99. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.

Q100. Write an SQL query to perform a realistic operation using SELECT, WHERE, LIKE, IN,

GROUP BY, or HAVING.