Jawaban Soal SQL MII

Dalam soal berikut, buatlah query untuk setiap pertanyaan deskriptif menjadi sebuah SQL code.

Soal SQL

1a. Menampilkan semua data pada table employee

SELECT *
FROM employee

1b. Menampilkan semua data employee dengan salary > 7000

SELECT *
FROM employee
WHERE salary > 7000

1c.

SELECT *
FROM employee AS e
WHERE e.first_name LIKE %a%
AND e.last_name LIKE a%a

1d.

SELECT *
FROM employee
WHERE hire_date < '2005'
ORDER BY hire_date ASC

2a.

SELECT country_id, country_name, region_name
FROM employee

2b.

SELECT first_name, last_name, job_title, department
FROM employee

2c.

SELECT e.first_name, e.last_name, em.first_name, em_last_name
FROM employee AS e
INNER JOIN employee AS em
WHERE e.employee_id = em.manager_id

--  if exists -- 

3a.

SELECT AVG(salary)
FROM employee

3b.

SELECT MAX(salary), MIN(salary)
FROM employee
WHERE department = 'Public Relation'

3c.

SELECT name, salary
FROM employee
WHERE salary > (SELECT AVG(salary)
      FROM employee);