Question 1
SELECT last_name,salary
FROM employees
WHERE salary >12000;
Question 2
SELECT last_name,department_id
FROM employees
WHERE employee_id = 176;
Question 3
SELECT last_name,salary
FROM employees
WHERE salary NOT BETWEEN 5000 AND 12000;
Quetion 4
SELECT last_name, job_id, hire_date
FROM employees
WHERE last_name LIKE 'Matos' OR last_name LIKE 'Taylor';
ORDER BY hire_date;
Question 5
SELECT last_name, department_id
FROM employees
WHERE department_id IN(20, 50)
ORDER BY last_name;
Question 6
SELECT last_name, salary
FROM employees
WHERE salary BETWEEN 5000 AND 12000
AND department_id IN (20, 50);
Question 7
SELECT last_name, hire_date
FROM employees
WHERE hire_date LIKE '%94';
Question 8
SELECT last_name, job_id
FROM employees
WHERE manager_id IS NULL;
Question 9
SELECT last_name, salary, commission_pct
FROM employees
WHERE commission_pct IS NOT NULL
ORDER BY salary, commission_pct DESC;
Question 10
SELECT last_name, salary
FROM employees
WHERE salary > '&name';
Question 11
SELECT employee_id, last_name, salary, department_id
FROM employees
WHERE manager_id = '&manager_num'
ORDER BY '&coloumn_name';
Question 12
SELECT last_name
FROM employees
WHERE last_name LIKE '__a%';
Question 13
SELECT last_name
FROM employees
WHERE last_name LIKE '%a%e%';
Question 14
SELECT last_name, job_id,salary
FROM employees
WHERE job_id IN('SA_REP', 'ST_CLERK');
WHERE salary NOT IN(2500, 3,500, 7000);
Question 15
SELECT last_name, salary, commission_pct
FROM employees
WHERE commission_pct IS NOT NULL;
WHERE commission_pct IN(20);
