SQL Query-Based Questions Quiz

Query-based questions are fundamental to extracting, filtering, and manipulating data within databases using SQL. In this quiz, you'll encounter a variety of SQL queries, covering topics such as SELECT statements, WHERE clauses, JOIN operations, GROUP BY clauses, and more.

Question 1

Write an SQL query to retrieve all columns from the "employees" table.

• SELECT * FROM employees;

• SELECT ALL employees;

• SELECT COLUMN employees;

• SELECT employees;

Question 2

Write an SQL query to retrieve distinct values from the "department" column of the "employees" table.

• SELECT DISTINCT department FROM employees;

• SELECT UNIQUE department FROM employees;

• SELECT department FROM employees DISTINCT;

• SELECT department DISTINCT FROM employees;

Question 3

Write an SQL query to retrieve the names of employees whose salary is greater than 50000.

• SELECT name FROM employees HAVING salary > 50000;

• SELECT name FROM employees WHERE salary > 50000;

• SELECT name FROM employees WHERE salary > '50000';

• SELECT name FROM employees GROUP BY salary HAVING salary > 50000;

Question 4

Write an SQL query to retrieve the number of employees in each department.

• SELECT COUNT() FROM employees ORDER BY department;

• SELECT COUNT(department) FROM employees GROUP BY department;

• SELECT COUNT() FROM employees GROUP BY department;

• SELECT COUNT(*) AS employees_count, department FROM employees;

Question 5

Write an SQL query to retrieve the highest salary from the "employees" table.

• SELECT TOP 1 salary FROM employees ORDER BY salary DESC;

• SELECT salary FROM employees WHERE salary = MAX(salary);

• SELECT salary FROM employees ORDER BY salary DESC LIMIT 1;

• SELECT MAX(salary) FROM employees;

Question 6

Write an SQL query to retrieve the names of employees whose names start with 'A'.

• SELECT name FROM employees WHERE name LIKE 'A%';

• SELECT name FROM employees WHERE name = 'A%';

• SELECT name FROM employees WHERE name LIKE '%A';

• SELECT name FROM employees WHERE name = '%A%';

Question 7

Write an SQL query to retrieve the average salary of all employees.

• SELECT AVERAGE(salary) FROM employees;

• SELECT AVG(salary) FROM employees;

• SELECT SUM(salary) / COUNT(salary) FROM employees;

• SELECT MEAN(salary) FROM employees;

Question 8

Write an SQL query to retrieve the names of employees who joined in the year 2021.

• SELECT name FROM employees WHERE JOIN_YEAR = 2021;

• SELECT name FROM employees WHERE JOIN_DATE LIKE '2021%';

• SELECT name FROM employees WHERE YEAR(JOIN_DATE) = 2021;

• SELECT name FROM employees WHERE JOIN_DATE BETWEEN '2021-01-01' AND '2021-12-31';

Question 9

Write an SQL query to retrieve the names of employees who belong to the 'Sales' department and have a salary greater than 60000.

• SELECT name FROM employees WHERE department = 'Sales' AND salary > 60000;

• SELECT name FROM employees WHERE department = 'Sales' OR salary > 60000;

• SELECT name FROM employees WHERE department = 'Sales' HAVING salary > 60000;

• SELECT name FROM employees GROUP BY department, salary HAVING department = 'Sales' AND salary > 60000;

Question 10

Write an SQL query to retrieve the names of employees who have 'Manager' in their job titles.

• SELECT name FROM employees WHERE job_title = 'Manager';

• SELECT name FROM employees WHERE job_title LIKE '%Manager%';

• SELECT name FROM employees WHERE job_title = '%Manager%';

• SELECT name FROM employees WHERE job_title LIKE 'Manager';