SQL Query Quiz Quiz

1. Question 1

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

   1. SELECT * FROM employees;
   2. SELECT ALL employees;
   3. SELECT COLUMN employees;
   4. SELECT employees;

2. Question 2

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

   1. SELECT DISTINCT department FROM employees;
   2. SELECT UNIQUE department FROM employees;
   3. SELECT department FROM employees DISTINCT;
   4. SELECT department DISTINCT FROM employees;

3. Question 3

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

   1. SELECT name FROM employees HAVING salary u003E 50000;
   2. SELECT name FROM employees WHERE salary u003E 50000;
   3. SELECT name FROM employees WHERE salary u003E '50000';
   4. SELECT name FROM employees GROUP BY salary HAVING salary u003E 50000;

4. Question 4

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

   1. SELECT COUNT() FROM employees ORDER BY department;
   2. SELECT COUNT(department) FROM employees GROUP BY department;
   3. SELECT COUNT(*) FROM employees GROUP BY department;
   4. SELECT COUNT(*) AS employees_count, department FROM employees;

5. Question 5

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

   1. SELECT TOP 1 salary FROM employees ORDER BY salary DESC;
   2. SELECT salary FROM employees WHERE salary = MAX(salary);
   3. SELECT salary FROM employees ORDER BY salary DESC LIMIT 1;
   4. SELECT MAX(salary) FROM employees;

6. Question 6

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

   1. SELECT name FROM employees WHERE name LIKE 'A%';
   2. SELECT name FROM employees WHERE name = 'A%';
   3. SELECT name FROM employees WHERE name LIKE '%A';
   4. SELECT name FROM employees WHERE name = '%A%;

7. Question 7

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

   1. SELECT AVERAGE(salary) FROM employees;
   2. SELECT AVG(salary) FROM employees;
   3. SELECT SUM(salary) / COUNT(salary) FROM employees;
   4. SELECT MEAN(salary) FROM employees;

8. Question 8

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

   1. SELECT name FROM employees WHERE JOIN_YEAR = 2021;
   2. SELECT name FROM employees WHERE JOIN_DATE LIKE '2021%';
   3. SELECT name FROM employees WHERE YEAR(JOIN_DATE) = 2021;
   4. SELECT name FROM employees WHERE JOIN_DATE BETWEEN '2021-01-01' AND '2021-12-31';

9. 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.

   1. SELECT name FROM employees WHERE department = 'Sales' AND salary u003E 60000;
   2. SELECT name FROM employees WHERE department = 'Sales' OR salary u003E 60000;
   3. SELECT name FROM employees WHERE department = 'Sales' HAVING salary u003E 60000;
   4. SELECT name FROM employees GROUP BY department, salary HAVING department = 'Sales' AND salary u003E 60000;

10. Question 10

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

    1. SELECT name FROM employees WHERE job_title = 'Manager';
    2. SELECT name FROM employees WHERE job_title LIKE '%Manager%';
    3. SELECT name FROM employees WHERE job_title = '%Manager%';
    4. SELECT name FROM employees WHERE job_title LIKE 'Manager';