SQL/lab4_ex3.sql at main · 95cs/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
/*
SELECT last_name, salary
FROM employees
WHERE salary > 12000;
*/

/*
SELECT last_name, department_id
FROM employees
WHERE employee_id = 176;
*/

/*
SELECT last_name, salary
FROM employees
WHERE salary NOT BETWEEN 5000 AND 12000;
*/

/*
SELECT last_name, job_id, hire_date
FROM employees
WHERE last_name IN ('Matos', 'Taylor')
ORDER BY hire_date;
*/

/*
SELECT last_name, department_id
FROM employees
WHERE department_id IN (20, 50)
ORDER BY last_name ASC;
*/

/*
SELECT last_name, department_id
FROM employees
WHERE department_id IN (20, 50)
ORDER BY last_name ASC;
*/

/*
SELECT last_name "Employee", salary "Monthly Salary"
FROM employees
WHERE salary BETWEEN 5000 AND 12000
AND department_id IN (20, 50);
*/

/*
SELECT last_name, hire_date
FROM employees
WHERE hire_date >= '01-JAN-10' AND hire_date < '01-JAN-11';
*/

/*
SELECT last_name, job_id
FROM employees
WHERE manager_id IS NULL;
*/

/*
SELECT last_name, salary, commission_pct
FROM employees
WHERE commission_pct IS NOT NULL
ORDER BY 2 DESC, 3 DESC;
*/

/*
SELECT last_name, salary
FROM employees
WHERE salary > &sal_amt;
*/

/*
SELECT employee_id, last_name, salary, department_id
FROM employees
WHERE manager_id = &mgr_num
ORDER BY &order_col;
*/

/*
SELECT last_name
FROM employees
WHERE last_name LIKE '__a%';
*/

/*
SELECT last_name
FROM employees
WHERE last_name LIKE '%a%'
AND last_name LIKE '%e%';
*/

/*
SELECT last_name, job_id, salary
FROM employees
WHERE job_id IN ('SA_REP', 'ST_CLERK')
AND salary NOT IN (2500, 3500, 7000);
*/

/*
SELECT last_name "Employee", salary "Monthly Salary",
commission_pct
FROM employees
WHERE commission_pct = .20;
*/