Practice your self.

 INTRODUCTION TO DATABASE 1B PRACTICAL
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);