Syeda saba shah

Bscs-ii section (A)

Database assignment lab 02
1. Write a query to display EMPLOYEE_ID, FIRST_NAME, and SALARY of employees
whose SALARY is less than $3000.
Query 1:
select first_name, employee_id, salary from employees where salary<30000;
+-------------+-------------+----------+
| first_name | employee_id | salary |
+-------------+-------------+----------+
| Steven | 100 | 24000.00 |
| Neena | 101 | 17000.00 |
| Lex | 102 | 17000.00 |
| Alexander | 103 | 9000.00 |
| Bruce | 104 | 6000.00 |
| David | 105 | 4800.00 |
| Valli | 106 | 4800.00 |
| Diana | 107 | 4200.00 |
| Nancy | 108 | 12000.00 |
| Daniel | 109 | 9000.00 |
| John | 110 | 8200.00 |
| Ismael | 111 | 7700.00 |
| Jose Manuel | 112 | 7800.00 |
| Luis | 113 | 6900.00 |
| Den | 114 | 11000.00 |
| Alexander | 115 | 3100.00 |
| Shelli | 116 | 2900.00 |
| Sigal | 117 | 2800.00 |
| Guy | 118 | 2600.00 |
| Karen | 119 | 2500.00 |
| Matthew | 120 | 8000.00 |
| Adam | 121 | 8200.00 |
| Payam | 122 | 7900.00 |
| Shanta | 123 | 6500.00 |
| Kevin | 124 | 5800.00 |
| Julia | 125 | 3200.00 |
| Irene | 126 | 2700.00 |
| James | 127 | 2400.00 |
| Steven | 128 | 2200.00 |
| Laura | 129 | 3300.00 |
| Mozhe | 130 | 2800.00 |
| James | 131 | 2500.00 |
| TJ | 132 | 2100.00 |
| Jason | 133 | 3300.00 |
| Michael | 134 | 2900.00 |
| Ki | 135 | 2400.00 |
| Hazel | 136 | 2200.00 |
| Renske | 137 | 3600.00 |
| Stephen | 138 | 3200.00 |
| John | 139 | 2700.00 |
| Joshua | 140 | 2500.00 |
| Trenna | 141 | 3500.00 |
| Curtis | 142 | 3100.00 |
| Randall | 143 | 2600.00 |
| Peter | 144 | 2500.00 |
| John | 145 | 14000.00 |
| Karen | 146 | 13500.00 |
| Alberto | 147 | 12000.00 |
| Gerald | 148 | 11000.00 |
| Eleni | 149 | 10500.00 |
| Peter | 150 | 10000.00 |
| David | 151 | 9500.00 |
| Peter | 152 | 9000.00 |
| Christopher | 153 | 8000.00 |
| Nanette | 154 | 7500.00 |
| Oliver | 155 | 7000.00 |
| Janette | 156 | 10000.00 |
| Patrick | 157 | 9500.00 |
| Allan | 158 | 9000.00 |
| Lindsey | 159 | 8000.00 |
| Louise | 160 | 7500.00 |
| Sarath | 161 | 7000.00 |
| Clara | 162 | 10500.00 |
| Danielle | 163 | 9500.00 |
| Mattea | 164 | 7200.00 |
| David | 165 | 6800.00 |
| Sundar | 166 | 6400.00 |
| Amit | 167 | 6200.00 |
| Lisa | 168 | 11500.00 |
| Harrison | 169 | 10000.00 |
| Tayler | 170 | 9600.00 |
| William | 171 | 7400.00 |
| Elizabeth | 172 | 7300.00 |
| Sundita | 173 | 6100.00 |
| Ellen | 174 | 11000.00 |
| Alyssa | 175 | 8800.00 |
| Jonathon | 176 | 8600.00 |
| Jack | 177 | 8400.00 |
| Kimberely | 178 | 7000.00 |
| Charles | 179 | 6200.00 |
| Winston | 180 | 3200.00 |
| Jean | 181 | 3100.00 |
| Martha | 182 | 2500.00 |
| Girard | 183 | 2800.00 |
| Nandita | 184 | 4200.00 |
| Alexis | 185 | 4100.00 |
| Julia | 186 | 3400.00 |
| Anthony | 187 | 3000.00 |
| Kelly | 188 | 3800.00 |
| Jennifer | 189 | 3600.00 |
| Timothy | 190 | 2900.00 |
| Randall | 191 | 2500.00 |
| Sarah | 192 | 4000.00 |
| Britney | 193 | 3900.00 |
| Samuel | 194 | 3200.00 |
| Vance | 195 | 2800.00 |
| Alana | 196 | 3100.00 |
| Kevin | 197 | 3000.00 |
| Donald | 198 | 2600.00 |
| Douglas | 199 | 2600.00 |
| Jennifer | 200 | 4400.00 |
| Michael | 201 | 13000.00 |
| Pat | 202 | 6000.00 |
| Susan | 203 | 6500.00 |
| Hermann | 204 | 10000.00 |
| Shelley | 205 | 12000.00 |
| William | 206 | 8300.00 |
+-------------+-------------+----------+
107 rows in set (0.01 sec)
2. Write a query to display FIRST_NAME, LASTNAME of all employees whose first name
starts with letter ‘A’
Query 2:
select first_name, last_name from employees where first_name like 'a%';
+------------+-----------+
| first_name | last_name |
+------------+-----------+
| Alexander | Hunold |
| Alexander | Khoo |
| Adam | Fripp |
| Alberto | Errazuriz |
| Allan | McEwen |
| Amit | Banda |
| Alyssa | Hutton |
| Alexis | Bull |
| Anthony | Cabrio |
| Alana | Walsh |
+------------+-----------+
10 rows in set (0.00 sec)
3. Write a query to display FIRST_NAME, JOB_ID, DEPARTMENT_ID of employees who
are either PU_CLERK or belongs to MANAGER_ID = 114.
Query 3:
select first_name, job_id, department_id from employees where job_id='pu_clerk' or
-> manager_id=114;
+------------+----------+---------------+
| first_name | job_id | department_id |
+------------+----------+---------------+
| Alexander | PU_CLERK | 30 |
| Shelli | PU_CLERK | 30 |
| Sigal | PU_CLERK | 30 |
| Guy | PU_CLERK | 30 |
| Karen | PU_CLERK | 30 |
+------------+----------+---------------+
5 rows in set (0.00 sec)
4. Write a query to display EMPLOYEE_ID, FIRST_NAME, and SALARY of employees
whose salaries lies in the range of $1500 to $3000;
Query 4:
select first_name, employee_id, salary from employees where
-> salary between 1500 and 30000;
+-------------+-------------+----------+
| first_name | employee_id | salary |
+-------------+-------------+----------+
| Steven | 100 | 24000.00 |
| Neena | 101 | 17000.00 |
| Lex | 102 | 17000.00 |
| Alexander | 103 | 9000.00 |
| Bruce | 104 | 6000.00 |
| David | 105 | 4800.00 |
| Valli | 106 | 4800.00 |
| Diana | 107 | 4200.00 |
| Nancy | 108 | 12000.00 |
| Daniel | 109 | 9000.00 |
| John | 110 | 8200.00 |
| Ismael | 111 | 7700.00 |
| Jose Manuel | 112 | 7800.00 |
| Luis | 113 | 6900.00 |
| Den | 114 | 11000.00 |
| Alexander | 115 | 3100.00 |
| Shelli | 116 | 2900.00 |
| Sigal | 117 | 2800.00 |
| Guy | 118 | 2600.00 |
| Karen | 119 | 2500.00 |
| Matthew | 120 | 8000.00 |
| Adam | 121 | 8200.00 |
| Payam | 122 | 7900.00 |
| Shanta | 123 | 6500.00 |
| Kevin | 124 | 5800.00 |
| Julia | 125 | 3200.00 |
| Irene | 126 | 2700.00 |
| James | 127 | 2400.00 |
| Steven | 128 | 2200.00 |
| Laura | 129 | 3300.00 |
| Mozhe | 130 | 2800.00 |
| James | 131 | 2500.00 |
| TJ | 132 | 2100.00 |
| Jason | 133 | 3300.00 |
| Michael | 134 | 2900.00 |
| Ki | 135 | 2400.00 |
| Hazel | 136 | 2200.00 |
| Renske | 137 | 3600.00 |
| Stephen | 138 | 3200.00 |
| John | 139 | 2700.00 |
| Joshua | 140 | 2500.00 |
| Trenna | 141 | 3500.00 |
| Curtis | 142 | 3100.00 |
| Randall | 143 | 2600.00 |
| Peter | 144 | 2500.00 |
| John | 145 | 14000.00 |
| Karen | 146 | 13500.00 |
| Alberto | 147 | 12000.00 |
| Gerald | 148 | 11000.00 |
| Eleni | 149 | 10500.00 |
| Peter | 150 | 10000.00 |
| David | 151 | 9500.00 |
| Peter | 152 | 9000.00 |
| Christopher | 153 | 8000.00 |
| Nanette | 154 | 7500.00 |
| Oliver | 155 | 7000.00 |
| Janette | 156 | 10000.00 |
| Patrick | 157 | 9500.00 |
| Allan | 158 | 9000.00 |
| Lindsey | 159 | 8000.00 |
| Louise | 160 | 7500.00 |
| Sarath | 161 | 7000.00 |
| Clara | 162 | 10500.00 |
| Danielle | 163 | 9500.00 |
| Mattea | 164 | 7200.00 |
| David | 165 | 6800.00 |
| Sundar | 166 | 6400.00 |
| Amit | 167 | 6200.00 |
| Lisa | 168 | 11500.00 |
| Harrison | 169 | 10000.00 |
| Tayler | 170 | 9600.00 |
| William | 171 | 7400.00 |
| Elizabeth | 172 | 7300.00 |
| Sundita | 173 | 6100.00 |
| Ellen | 174 | 11000.00 |
| Alyssa | 175 | 8800.00 |
| Jonathon | 176 | 8600.00 |
| Jack | 177 | 8400.00 |
| Kimberely | 178 | 7000.00 |
| Charles | 179 | 6200.00 |
| Winston | 180 | 3200.00 |
 | Jean | 181 | 3100.00 |
| Martha | 182 | 2500.00 |
| Girard | 183 | 2800.00 |
| Nandita | 184 | 4200.00 |
| Alexis | 185 | 4100.00 |
| Julia | 186 | 3400.00 |
| Anthony | 187 | 3000.00 |
| Kelly | 188 | 3800.00 |
| Jennifer | 189 | 3600.00 |
| Timothy | 190 | 2900.00 |
| Randall | 191 | 2500.00 |
| Sarah | 192 | 4000.00 |
| Britney | 193 | 3900.00 |
| Samuel | 194 | 3200.00 |
| Vance | 195 | 2800.00 |
| Alana | 196 | 3100.00 |
| Kevin | 197 | 3000.00 |
| Donald | 198 | 2600.00 |
| Douglas | 199 | 2600.00 |
| Jennifer | 200 | 4400.00 |
| Michael | 201 | 13000.00 |
| Pat | 202 | 6000.00 |
| Susan | 203 | 6500.00 |
| Hermann | 204 | 10000.00 |
| Shelley | 205 | 12000.00 |
| William | 206 | 8300.00 |
+-------------+-------------+----------+
107 rows in set (0.00 sec)
5. Write a query to display first names of all employees that end with alphabet ‘N’
Query 5:
select first_name from employees where first_name like '%n';
+------------+
| first_name |
+------------+
| Steven |
| John |
| Den |
| Karen |
| Kevin |
| Steven |
| Jason |
 | Stephen |
| John |
| John |
| Karen |
| Allan |
| Harrison |
| Ellen |
| Jonathon |
| Winston |
| Jean |
| Kevin |
| Susan |
| Hermann |
+------------+
20 rows in set (0.00 sec)
6. Write a query to display FIRST_NAME, JOB_ID, DEPARTMENT_ID of employees who
are not PU_CLERK.
Query 6:
select first_name, job_id, department_id from employees where job_id !='pu_clerk';
+-------------+------------+---------------+
| first_name | job_id | department_id |
+-------------+------------+---------------+
| Steven | AD_PRES | 90 |
| Neena | AD_VP | 90 |
| Lex | AD_VP | 90 |
| Alexander | IT_PROG | 60 |
| Bruce | IT_PROG | 60 |
| David | IT_PROG | 60 |
| Valli | IT_PROG | 60 |
| Diana | IT_PROG | 60 |
| Nancy | FI_MGR | 100 |
| Daniel | FI_ACCOUNT | 100 |
| John | FI_ACCOUNT | 100 |
| Ismael | FI_ACCOUNT | 100 |
| Jose Manuel | FI_ACCOUNT | 100 |
| Luis | FI_ACCOUNT | 100 |
| Den | PU_MAN | 30 |
| Matthew | ST_MAN | 50 |
| Adam | ST_MAN | 50 |
| Payam | ST_MAN | 50 |
| Shanta | ST_MAN | 50 |
| Kevin | ST_MAN | 50 |
| Julia | ST_CLERK | 50 |
| Irene | ST_CLERK | 50 |
| James | ST_CLERK | 50 |
| Steven | ST_CLERK | 50 |
| Laura | ST_CLERK | 50 |
| Mozhe | ST_CLERK | 50 |
| James | ST_CLERK | 50 |
| TJ | ST_CLERK | 50 |
| Jason | ST_CLERK | 50 |
| Michael | ST_CLERK | 50 |
| Ki | ST_CLERK | 50 |
| Hazel | ST_CLERK | 50 |
| Renske | ST_CLERK | 50 |
| Stephen | ST_CLERK | 50 |
| John | ST_CLERK | 50 |
| Joshua | ST_CLERK | 50 |
| Trenna | ST_CLERK | 50 |
| Curtis | ST_CLERK | 50 |
| Randall | ST_CLERK | 50 |
| Peter | ST_CLERK | 50 |
| John | SA_MAN | 80 |
| Karen | SA_MAN | 80 |
| Alberto | SA_MAN | 80 |
| Gerald | SA_MAN | 80 |
| Eleni | SA_MAN | 80 |
| Peter | SA_REP | 80 |
| David | SA_REP | 80 |
| Peter | SA_REP | 80 |
| Christopher | SA_REP | 80 |
| Nanette | SA_REP | 80 |
| Oliver | SA_REP | 80 |
| Janette | SA_REP | 80 |
| Patrick | SA_REP | 80 |
| Allan | SA_REP | 80 |
| Lindsey | SA_REP | 80 |
| Louise | SA_REP | 80 |
| Sarath | SA_REP | 80 |
| Clara | SA_REP | 80 |
| Danielle | SA_REP | 80 |
| Mattea | SA_REP | 80 |
| David | SA_REP | 80 |
| Sundar | SA_REP | 80 |
| Amit | SA_REP | 80 |
| Lisa | SA_REP | 80 |
| Harrison | SA_REP | 80 |
| Tayler | SA_REP | 80 |
| William | SA_REP | 80 |
| Elizabeth | SA_REP | 80 |
| Sundita | SA_REP | 80 |
| Ellen | SA_REP | 80 |
| Alyssa | SA_REP | 80 |
| Jonathon | SA_REP | 80 |
| Jack | SA_REP | 80 |
| Kimberely | SA_REP | NULL |
| Charles | SA_REP | 80 |
| Winston | SH_CLERK | 50 |
| Jean | SH_CLERK | 50 |
| Martha | SH_CLERK | 50 |
| Girard | SH_CLERK | 50 |
| Nandita | SH_CLERK | 50 |
| Alexis | SH_CLERK | 50 |
| Julia | SH_CLERK | 50 |
| Anthony | SH_CLERK | 50 |
| Kelly | SH_CLERK | 50 |
| Jennifer | SH_CLERK | 50 |
| Timothy | SH_CLERK | 50 |
| Randall | SH_CLERK | 50 |
| Sarah | SH_CLERK | 50 |
| Britney | SH_CLERK | 50 |
| Samuel | SH_CLERK | 50 |
| Vance | SH_CLERK | 50 |
| Alana | SH_CLERK | 50 |
| Kevin | SH_CLERK | 50 |
| Donald | SH_CLERK | 50 |
| Douglas | SH_CLERK | 50 |
| Jennifer | AD_ASST | 10 |
| Michael | MK_MAN | 20 |
| Pat | MK_REP | 20 |
| Susan | HR_REP | 40 |
| Hermann | PR_REP | 70 |
| Shelley | AC_MGR | 110 |
 | William | AC_ACCOUNT | 110 |
+-------------+------------+---------------+
102 rows in set (0.00 sec)
7. Write a query to display EMPLOYEE_ID, FIRST_NAME, and SALARY of those
employees who do not have salaries of $3300, $3200, $2200.
Query 7:
select first_name, employee_id, salary from employees where salary not
in(3300,3200,2200);
+-------------+-------------+----------+
| first_name | employee_id | salary |
+-------------+-------------+----------+
| Steven | 100 | 24000.00 |
| Neena | 101 | 17000.00 |
| Lex | 102 | 17000.00 |
| Alexander | 103 | 9000.00 |
| Bruce | 104 | 6000.00 |
| David | 105 | 4800.00 |
| Valli | 106 | 4800.00 |
| Diana | 107 | 4200.00 |
| Nancy | 108 | 12000.00 |
| Daniel | 109 | 9000.00 |
| John | 110 | 8200.00 |
| Ismael | 111 | 7700.00 |
| Jose Manuel | 112 | 7800.00 |
| Luis | 113 | 6900.00 |
| Den | 114 | 11000.00 |
| Alexander | 115 | 3100.00 |
| Shelli | 116 | 2900.00 |
| Sigal | 117 | 2800.00 |
| Guy | 118 | 2600.00 |
| Karen | 119 | 2500.00 |
| Matthew | 120 | 8000.00 |
| Adam | 121 | 8200.00 |
| Payam | 122 | 7900.00 |
| Shanta | 123 | 6500.00 |
| Kevin | 124 | 5800.00 |
| Irene | 126 | 2700.00 |
| James | 127 | 2400.00 |
| Mozhe | 130 | 2800.00 |
| James | 131 | 2500.00 |
| TJ | 132 | 2100.00 |
| Michael | 134 | 2900.00 |
| Ki | 135 | 2400.00 |
| Renske | 137 | 3600.00 |
| John | 139 | 2700.00 |
| Joshua | 140 | 2500.00 |
| Trenna | 141 | 3500.00 |
| Curtis | 142 | 3100.00 |
| Randall | 143 | 2600.00 |
| Peter | 144 | 2500.00 |
| John | 145 | 14000.00 |
| Karen | 146 | 13500.00 |
| Alberto | 147 | 12000.00 |
| Gerald | 148 | 11000.00 |
| Eleni | 149 | 10500.00 |
| Peter | 150 | 10000.00 |
| David | 151 | 9500.00 |
| Peter | 152 | 9000.00 |
| Christopher | 153 | 8000.00 |
| Nanette | 154 | 7500.00 |
| Oliver | 155 | 7000.00 |
| Janette | 156 | 10000.00 |
| Patrick | 157 | 9500.00 |
| Allan | 158 | 9000.00 |
| Lindsey | 159 | 8000.00 |
| Louise | 160 | 7500.00 |
| Sarath | 161 | 7000.00 |
| Clara | 162 | 10500.00 |
| Danielle | 163 | 9500.00 |
| Mattea | 164 | 7200.00 |
| David | 165 | 6800.00 |
| Sundar | 166 | 6400.00 |
| Amit | 167 | 6200.00 |
| Lisa | 168 | 11500.00 |
| Harrison | 169 | 10000.00 |
| Tayler | 170 | 9600.00 |
| William | 171 | 7400.00 |
| Elizabeth | 172 | 7300.00 |
| Sundita | 173 | 6100.00 |
| Ellen | 174 | 11000.00 |
| Alyssa | 175 | 8800.00 |
| Jonathon | 176 | 8600.00 |
 | Jack | 177 | 8400.00 |
| Kimberely | 178 | 7000.00 |
| Charles | 179 | 6200.00 |
| Jean | 181 | 3100.00 |
| Martha | 182 | 2500.00 |
| Girard | 183 | 2800.00 |
| Nandita | 184 | 4200.00 |
| Alexis | 185 | 4100.00 |
| Julia | 186 | 3400.00 |
| Anthony | 187 | 3000.00 |
| Kelly | 188 | 3800.00 |
| Jennifer | 189 | 3600.00 |
| Timothy | 190 | 2900.00 |
| Randall | 191 | 2500.00 |
| Sarah | 192 | 4000.00 |
| Britney | 193 | 3900.00 |
| Vance | 195 | 2800.00 |
| Alana | 196 | 3100.00 |
| Kevin | 197 | 3000.00 |
| Donald | 198 | 2600.00 |
| Douglas | 199 | 2600.00 |
| Jennifer | 200 | 4400.00 |
| Michael | 201 | 13000.00 |
| Pat | 202 | 6000.00 |
| Susan | 203 | 6500.00 |
| Hermann | 204 | 10000.00 |
| Shelley | 205 | 12000.00 |
| William | 206 | 8300.00 |
+-------------+-------------+----------+
99 rows in set (0.00 sec)
8. Write a query to display names of those employees whose first name starts with ‘A’
and ends with ‘N’.
Query 8:
select first_name from employees where first_name like 'a%n';
+------------+
| first_name |
+------------+
| Allan |
+------------+
1 row in set (0.00 sec)
9. Write a query to display the list of employee names that have letters ‘LA’ in their
names.
Query 9:
select first_name from employees where first_name like 'la%';
+------------+
| first_name |
+------------+
| Laura |
+------------+
1 row in set (0.00 sec)
10. Write a query to display the EMPLOYEE_ID, FIRST_NAME, and SALARY of employees.
In that, the highest paid employee should display first and lowest paid should display
last.
Query 10:
select employee_id, first_name, salary from employees order by salary desc;
+-------------+-------------+----------+
| employee_id | first_name | salary |
+-------------+-------------+----------+
| 100 | Steven | 24000.00 |
| 101 | Neena | 17000.00 |
| 102 | Lex | 17000.00 |
| 145 | John | 14000.00 |
| 146 | Karen | 13500.00 |
| 201 | Michael | 13000.00 |
| 108 | Nancy | 12000.00 |
| 147 | Alberto | 12000.00 |
| 205 | Shelley | 12000.00 |
| 168 | Lisa | 11500.00 |
| 114 | Den | 11000.00 |
| 148 | Gerald | 11000.00 |
| 174 | Ellen | 11000.00 |
| 149 | Eleni | 10500.00 |
| 162 | Clara | 10500.00 |
| 150 | Peter | 10000.00 |
| 156 | Janette | 10000.00 |
| 169 | Harrison | 10000.00 |
| 204 | Hermann | 10000.00 |
| 170 | Tayler | 9600.00 |
| 151 | David | 9500.00 |
| 157 | Patrick | 9500.00 |
| 163 | Danielle | 9500.00 |
| 103 | Alexander | 9000.00 |
| 109 | Daniel | 9000.00 |
| 152 | Peter | 9000.00 |
| 158 | Allan | 9000.00 |
| 175 | Alyssa | 8800.00 |
| 176 | Jonathon | 8600.00 |
| 177 | Jack | 8400.00 |
| 206 | William | 8300.00 |
| 110 | John | 8200.00 |
| 121 | Adam | 8200.00 |
| 120 | Matthew | 8000.00 |
| 153 | Christopher | 8000.00 |
| 159 | Lindsey | 8000.00 |
| 122 | Payam | 7900.00 |
| 112 | Jose Manuel | 7800.00 |
| 111 | Ismael | 7700.00 |
| 154 | Nanette | 7500.00 |
| 160 | Louise | 7500.00 |
| 171 | William | 7400.00 |
| 172 | Elizabeth | 7300.00 |
| 164 | Mattea | 7200.00 |
| 155 | Oliver | 7000.00 |
| 161 | Sarath | 7000.00 |
| 178 | Kimberely | 7000.00 |
| 113 | Luis | 6900.00 |
| 165 | David | 6800.00 |
| 123 | Shanta | 6500.00 |
| 203 | Susan | 6500.00 |
| 166 | Sundar | 6400.00 |
| 167 | Amit | 6200.00 |
| 179 | Charles | 6200.00 |
| 173 | Sundita | 6100.00 |
| 104 | Bruce | 6000.00 |
| 202 | Pat | 6000.00 |
| 124 | Kevin | 5800.00 |
| 105 | David | 4800.00 |
| 106 | Valli | 4800.00 |
| 200 | Jennifer | 4400.00 |
| 107 | Diana | 4200.00 |
| 184 | Nandita | 4200.00 |
| 185 | Alexis | 4100.00 |
| 192 | Sarah | 4000.00 |
| 193 | Britney | 3900.00 |
| 188 | Kelly | 3800.00 |
| 137 | Renske | 3600.00 |
| 189 | Jennifer | 3600.00 |
| 141 | Trenna | 3500.00 |
| 186 | Julia | 3400.00 |
| 129 | Laura | 3300.00 |
| 133 | Jason | 3300.00 |
| 125 | Julia | 3200.00 |
| 138 | Stephen | 3200.00 |
| 180 | Winston | 3200.00 |
| 194 | Samuel | 3200.00 |
| 115 | Alexander | 3100.00 |
| 142 | Curtis | 3100.00 |
| 181 | Jean | 3100.00 |
| 196 | Alana | 3100.00 |
| 187 | Anthony | 3000.00 |
| 197 | Kevin | 3000.00 |
| 116 | Shelli | 2900.00 |
| 134 | Michael | 2900.00 |
| 190 | Timothy | 2900.00 |
| 117 | Sigal | 2800.00 |
| 130 | Mozhe | 2800.00 |
| 183 | Girard | 2800.00 |
| 195 | Vance | 2800.00 |
| 126 | Irene | 2700.00 |
| 139 | John | 2700.00 |
| 118 | Guy | 2600.00 |
| 143 | Randall | 2600.00 |
| 198 | Donald | 2600.00 |
| 199 | Douglas | 2600.00 |
| 119 | Karen | 2500.00 |
| 131 | James | 2500.00 |
| 140 | Joshua | 2500.00 |
| 144 | Peter | 2500.00 |
| 182 | Martha | 2500.00 |
| 191 | Randall | 2500.00 |
| 127 | James | 2400.00 |
| 135 | Ki | 2400.00 |
| 128 | Steven | 2200.00 |
 | 136 | Hazel | 2200.00 |
| 132 | TJ | 2100.00 |
+-------------+-------------+----------+
107 rows in set (0.00 sec)
11. Write a query to display FIRST_NAME of employees that have "a" in the second
position.
Query 11:
select first_name from employees where first_name like '_a%';
+------------+
| first_name |
+------------+
| David |
| Valli |
| Nancy |
| Daniel |
| Karen |
| Matthew |
| Payam |
| James |
| Laura |
| James |
| Jason |
| Hazel |
| Randall |
| Karen |
| David |
| Nanette |
| Janette |
| Patrick |
| Sarath |
| Danielle |
| Mattea |
| David |
| Harrison |
| Tayler |
| Jack |
| Martha |
| Nandita |
| Randall |
| Sarah |
| Samuel |
 | Vance |
| Pat |
+------------+
32 rows in set (0.00 sec)
12. Write a query to display EMPLOYEE_ID, FIRST_NAME, and SALARY of employees
whose salaries do not lies in the range of $1500 to $3000;
Query 12:
select first_name, employee_id, salary from employees where salary between 1500
and 3000;
+------------+-------------+---------+
| first_name | employee_id | salary |
+------------+-------------+---------+
| Shelli | 116 | 2900.00 |
| Sigal | 117 | 2800.00 |
| Guy | 118 | 2600.00 |
| Karen | 119 | 2500.00 |
| Irene | 126 | 2700.00 |
| James | 127 | 2400.00 |
| Steven | 128 | 2200.00 |
| Mozhe | 130 | 2800.00 |
| James | 131 | 2500.00 |
| TJ | 132 | 2100.00 |
| Michael | 134 | 2900.00 |
| Ki | 135 | 2400.00 |
| Hazel | 136 | 2200.00 |
| John | 139 | 2700.00 |
| Joshua | 140 | 2500.00 |
| Randall | 143 | 2600.00 |
| Peter | 144 | 2500.00 |
| Martha | 182 | 2500.00 |
| Girard | 183 | 2800.00 |
| Anthony | 187 | 3000.00 |
| Timothy | 190 | 2900.00 |
| Randall | 191 | 2500.00 |
| Vance | 195 | 2800.00 |
| Kevin | 197 | 3000.00 |
| Donald | 198 | 2600.00 |
| Douglas | 199 | 2600.00 |
+------------+-------------+---------+
26 rows in set (0.00 sec)
13. Write a query to display the LAST_NAME of employees whose LAST_NAME have
exactly 6 characters.
Query 13:
select last_name from employees where last_name like '______';
+-----------+
| last_name |
+-----------+
| Hunold |
| Austin |
| Faviet |
| Tobias |
| Himuro |
| Landry |
| Markle |
| Bissot |
| Marlow |
| Mallin |
| Rogers |
| Ladwig |
| Stiles |
| Davies |
| Vargas |
| Tucker |
| McEwen |
| Sewall |
| Greene |
| Hutton |
| Taylor |
| Taylor |
| Fleaur |
| Cabrio |
| McCain |
| Feeney |
| Whalen |
| Mavris |
+-----------+
28 rows in set (0.00 sec)
14. Write a query to display FIRST_NAME, LAST_NAME and DEPARTMENT_ID of all
employees in departments 30 or 100 in ascending order.
Query 14:
select first_name,last_name,department_id from employees where department_id=
30 or
-> 100 order by department_id asc;
+-------------+-------------+---------------+
| first_name | last_name | department_id |
+-------------+-------------+---------------+
| Kimberely | Grant | NULL |
| Jennifer | Whalen | 10 |
| Michael | Hartstein | 20 |
| Pat | Fay | 20 |
| Den | Raphaely | 30 |
| Alexander | Khoo | 30 |
| Shelli | Baida | 30 |
| Sigal | Tobias | 30 |
| Guy | Himuro | 30 |
| Karen | Colmenares | 30 |
| Susan | Mavris | 40 |
| Matthew | Weiss | 50 |
| Adam | Fripp | 50 |
| Payam | Kaufling | 50 |
| Shanta | Vollman | 50 |
| Kevin | Mourgos | 50 |
| Julia | Nayer | 50 |
| Irene | Mikkilineni | 50 |
| James | Landry | 50 |
| Steven | Markle | 50 |
| Laura | Bissot | 50 |
| Mozhe | Atkinson | 50 |
| James | Marlow | 50 |
| TJ | Olson | 50 |
| Jason | Mallin | 50 |
| Michael | Rogers | 50 |
| Ki | Gee | 50 |
| Hazel | Philtanker | 50 |
| Renske | Ladwig | 50 |
| Stephen | Stiles | 50 |
| John | Seo | 50 |
| Joshua | Patel | 50 |
| Trenna | Rajs | 50 |
| Curtis | Davies | 50 |
| Randall | Matos | 50 |
| Peter | Vargas | 50 |
| Winston | Taylor | 50 |
| Jean | Fleaur | 50 |
| Martha | Sullivan | 50 |
| Girard | Geoni | 50 |
| Nandita | Sarchand | 50 |
| Alexis | Bull | 50 |
| Julia | Dellinger | 50 |
| Anthony | Cabrio | 50 |
| Kelly | Chung | 50 |
| Jennifer | Dilly | 50 |
| Timothy | Gates | 50 |
| Randall | Perkins | 50 |
| Sarah | Bell | 50 |
| Britney | Everett | 50 |
| Samuel | McCain | 50 |
| Vance | Jones | 50 |
| Alana | Walsh | 50 |
| Kevin | Feeney | 50 |
| Donald | OConnell | 50 |
| Douglas | Grant | 50 |
| Alexander | Hunold | 60 |
| Bruce | Ernst | 60 |
| David | Austin | 60 |
| Valli | Pataballa | 60 |
| Diana | Lorentz | 60 |
| Hermann | Baer | 70 |
| John | Russell | 80 |
| Karen | Partners | 80 |
| Alberto | Errazuriz | 80 |
| Gerald | Cambrault | 80 |
| Eleni | Zlotkey | 80 |
| Peter | Tucker | 80 |
| David | Bernstein | 80 |
| Peter | Hall | 80 |
| Christopher | Olsen | 80 |
| Nanette | Cambrault | 80 |
| Oliver | Tuvault | 80 |
| Janette | King | 80 |
| Patrick | Sully | 80 |
| Allan | McEwen | 80 |
 | Lindsey | Smith | 80 |
| Louise | Doran | 80 |
| Sarath | Sewall | 80 |
| Clara | Vishney | 80 |
| Danielle | Greene | 80 |
| Mattea | Marvins | 80 |
| David | Lee | 80 |
| Sundar | Ande | 80 |
| Amit | Banda | 80 |
| Lisa | Ozer | 80 |
| Harrison | Bloom | 80 |
| Tayler | Fox | 80 |
| William | Smith | 80 |
| Elizabeth | Bates | 80 |
| Sundita | Kumar | 80 |
| Ellen | Abel | 80 |
| Alyssa | Hutton | 80 |
| Jonathon | Taylor | 80 |
| Jack | Livingston | 80 |
| Charles | Johnson | 80 |
| Steven | King | 90 |
| Neena | Kochhar | 90 |
| Lex | De Haan | 90 |
| Nancy | Greenberg | 100 |
| Daniel | Faviet | 100 |
| John | Chen | 100 |
| Ismael | Sciarra | 100 |
| Jose Manuel | Urman | 100 |
| Luis | Popp | 100 |
| Shelley | Higgins | 110 |
| William | Gietz | 110 |
+-------------+-------------+---------------+
107 rows in set (0.00 sec)
15. Write a query to display FIRST_NAME, LAST_NAME and SALARY for all employees
whose salary is not in the range $10,000 through $15,000 and are in department 30
or 100.
Query 15:
select first_name, last_name,salary from employees where salary not between
100000 and 15000 and department_id in(30, 100);
+-------------+------------+----------+
| first_name | last_name | salary |
 +-------------+------------+----------+
| Den | Raphaely | 11000.00 |
| Alexander | Khoo | 3100.00 |
| Shelli | Baida | 2900.00 |
| Sigal | Tobias | 2800.00 |
| Guy | Himuro | 2600.00 |
| Karen | Colmenares | 2500.00 |
| Nancy | Greenberg | 12000.00 |
| Daniel | Faviet | 9000.00 |
| John | Chen | 8200.00 |
| Ismael | Sciarra | 7700.00 |
| Jose Manuel | Urman | 7800.00 |
| Luis | Popp | 6900.00 |
+-------------+------------+----------+
12 rows in set (0.00 sec)
16. Write a query to display FIRST_NAME, LAST_NAME and HIRE_DATE for all employees
who were hired in 1987.
Query 16:
select first_name, last_name,hire_date from employees where hire_date like
"1987%";
+------------+-----------+------------+
| first_name | last_name | hire_date |
+------------+-----------+------------+
| Steven | King | 1987-06-17 |
| Jennifer | Whalen | 1987-09-17 |
+------------+-----------+------------+
2 rows in set (0.00 sec)
17. Write a query to display the LAST_NAME of employees whose LAST_NAME have
exactly 6 characters.
Query 17:
select last_name from employees where last_name like '______';
+-----------+
| last_name |
+-----------+
| Hunold |
| Austin |
| Faviet |
| Tobias |
| Himuro |
| Landry |
| Markle |
 | Bissot |
| Marlow |
| Mallin |
| Rogers |
| Ladwig |
| Stiles |
| Davies |
| Vargas |
| Tucker |
| McEwen |
| Sewall |
| Greene |
| Hutton |
| Taylor |
| Taylor |
| Fleaur |
| Cabrio |
| McCain |
| Feeney |
| Whalen |
| Mavris |
+-----------+
28 rows in set (0.00 sec)
18. Write a query to display FIRST_NAME, SALARY and PF (15% of salary) of all
employees
Query 18:
select first_name, salary , (salary* 0.15) as pf from employees;
+-------------+----------+-----------+
| first_name | salary | pf |
+-------------+----------+-----------+
| Steven | 24000.00 | 3600.0000 |
| Neena | 17000.00 | 2550.0000 |
| Lex | 17000.00 | 2550.0000 |
| Alexander | 9000.00 | 1350.0000 |
| Bruce | 6000.00 | 900.0000 |
| David | 4800.00 | 720.0000 |
| Valli | 4800.00 | 720.0000 |
| Diana | 4200.00 | 630.0000 |
| Nancy | 12000.00 | 1800.0000 |
| Daniel | 9000.00 | 1350.0000 |
| John | 8200.00 | 1230.0000 |
| Ismael | 7700.00 | 1155.0000 |
| Jose Manuel | 7800.00 | 1170.0000 |
| Luis | 6900.00 | 1035.0000 |
| Den | 11000.00 | 1650.0000 |
| Alexander | 3100.00 | 465.0000 |
| Shelli | 2900.00 | 435.0000 |
| Sigal | 2800.00 | 420.0000 |
| Guy | 2600.00 | 390.0000 |
| Karen | 2500.00 | 375.0000 |
| Matthew | 8000.00 | 1200.0000 |
| Adam | 8200.00 | 1230.0000 |
| Payam | 7900.00 | 1185.0000 |
| Shanta | 6500.00 | 975.0000 |
| Kevin | 5800.00 | 870.0000 |
| Julia | 3200.00 | 480.0000 |
| Irene | 2700.00 | 405.0000 |
| James | 2400.00 | 360.0000 |
| Steven | 2200.00 | 330.0000 |
| Laura | 3300.00 | 495.0000 |
| Mozhe | 2800.00 | 420.0000 |
| James | 2500.00 | 375.0000 |
| TJ | 2100.00 | 315.0000 |
| Jason | 3300.00 | 495.0000 |
| Michael | 2900.00 | 435.0000 |
| Ki | 2400.00 | 360.0000 |
| Hazel | 2200.00 | 330.0000 |
| Renske | 3600.00 | 540.0000 |
| Stephen | 3200.00 | 480.0000 |
| John | 2700.00 | 405.0000 |
| Joshua | 2500.00 | 375.0000 |
| Trenna | 3500.00 | 525.0000 |
| Curtis | 3100.00 | 465.0000 |
| Randall | 2600.00 | 390.0000 |
| Peter | 2500.00 | 375.0000 |
| John | 14000.00 | 2100.0000 |
| Karen | 13500.00 | 2025.0000 |
| Alberto | 12000.00 | 1800.0000 |
| Gerald | 11000.00 | 1650.0000 |
| Eleni | 10500.00 | 1575.0000 |
| Peter | 10000.00 | 1500.0000 |
| David | 9500.00 | 1425.0000 |
| Peter | 9000.00 | 1350.0000 |
| Christopher | 8000.00 | 1200.0000 |
| Nanette | 7500.00 | 1125.0000 |
| Oliver | 7000.00 | 1050.0000 |
| Janette | 10000.00 | 1500.0000 |
| Patrick | 9500.00 | 1425.0000 |
| Allan | 9000.00 | 1350.0000 |
| Lindsey | 8000.00 | 1200.0000 |
| Louise | 7500.00 | 1125.0000 |
| Sarath | 7000.00 | 1050.0000 |
| Clara | 10500.00 | 1575.0000 |
| Danielle | 9500.00 | 1425.0000 |
| Mattea | 7200.00 | 1080.0000 |
| David | 6800.00 | 1020.0000 |
| Sundar | 6400.00 | 960.0000 |
| Amit | 6200.00 | 930.0000 |
| Lisa | 11500.00 | 1725.0000 |
| Harrison | 10000.00 | 1500.0000 |
| Tayler | 9600.00 | 1440.0000 |
| William | 7400.00 | 1110.0000 |
| Elizabeth | 7300.00 | 1095.0000 |
| Sundita | 6100.00 | 915.0000 |
| Ellen | 11000.00 | 1650.0000 |
| Alyssa | 8800.00 | 1320.0000 |
| Jonathon | 8600.00 | 1290.0000 |
| Jack | 8400.00 | 1260.0000 |
| Kimberely | 7000.00 | 1050.0000 |
| Charles | 6200.00 | 930.0000 |
| Winston | 3200.00 | 480.0000 |
| Jean | 3100.00 | 465.0000 |
| Martha | 2500.00 | 375.0000 |
| Girard | 2800.00 | 420.0000 |
| Nandita | 4200.00 | 630.0000 |
| Alexis | 4100.00 | 615.0000 |
| Julia | 3400.00 | 510.0000 |
| Anthony | 3000.00 | 450.0000 |
| Kelly | 3800.00 | 570.0000 |
| Jennifer | 3600.00 | 540.0000 |
| Timothy | 2900.00 | 435.0000 |
| Randall | 2500.00 | 375.0000 |
| Sarah | 4000.00 | 600.0000 |
 | Britney | 3900.00 | 585.0000 |
| Samuel | 3200.00 | 480.0000 |
| Vance | 2800.00 | 420.0000 |
| Alana | 3100.00 | 465.0000 |
| Kevin | 3000.00 | 450.0000 |
| Donald | 2600.00 | 390.0000 |
| Douglas | 2600.00 | 390.0000 |
| Jennifer | 4400.00 | 660.0000 |
| Michael | 13000.00 | 1950.0000 |
| Pat | 6000.00 | 900.0000 |
| Susan | 6500.00 | 975.0000 |
| Hermann | 10000.00 | 1500.0000 |
| Shelley | 12000.00 | 1800.0000 |
| William | 8300.00 | 1245.0000 |
+-------------+----------+-----------+
107 rows in set (0.00 sec)
19. Write a query to display FIRST_NAME, SALARY and commission amount (% of salary)
of all employees.
Query 19:
select first_name, salary , (salary* ifnull(commission_pct, 0)) as commission_amount
from employees;
+-------------+----------+-------------------+
| first_name | salary | commission_amount |
+-------------+----------+-------------------+
| Steven | 24000.00 | 0.0000 |
| Neena | 17000.00 | 0.0000 |
| Lex | 17000.00 | 0.0000 |
| Alexander | 9000.00 | 0.0000 |
| Bruce | 6000.00 | 0.0000 |
| David | 4800.00 | 0.0000 |
| Valli | 4800.00 | 0.0000 |
| Diana | 4200.00 | 0.0000 |
| Nancy | 12000.00 | 0.0000 |
| Daniel | 9000.00 | 0.0000 |
| John | 8200.00 | 0.0000 |
| Ismael | 7700.00 | 0.0000 |
| Jose Manuel | 7800.00 | 0.0000 |
| Luis | 6900.00 | 0.0000 |
| Den | 11000.00 | 0.0000 |
| Alexander | 3100.00 | 0.0000 |
| Shelli | 2900.00 | 0.0000 |
| Sigal | 2800.00 | 0.0000 |
| Guy | 2600.00 | 0.0000 |
| Karen | 2500.00 | 0.0000 |
| Matthew | 8000.00 | 0.0000 |
| Adam | 8200.00 | 0.0000 |
| Payam | 7900.00 | 0.0000 |
| Shanta | 6500.00 | 0.0000 |
| Kevin | 5800.00 | 0.0000 |
| Julia | 3200.00 | 0.0000 |
| Irene | 2700.00 | 0.0000 |
| James | 2400.00 | 0.0000 |
| Steven | 2200.00 | 0.0000 |
| Laura | 3300.00 | 0.0000 |
| Mozhe | 2800.00 | 0.0000 |
| James | 2500.00 | 0.0000 |
| TJ | 2100.00 | 0.0000 |
| Jason | 3300.00 | 0.0000 |
| Michael | 2900.00 | 0.0000 |
| Ki | 2400.00 | 0.0000 |
| Hazel | 2200.00 | 0.0000 |
| Renske | 3600.00 | 0.0000 |
| Stephen | 3200.00 | 0.0000 |
| John | 2700.00 | 0.0000 |
| Joshua | 2500.00 | 0.0000 |
| Trenna | 3500.00 | 0.0000 |
| Curtis | 3100.00 | 0.0000 |
| Randall | 2600.00 | 0.0000 |
| Peter | 2500.00 | 0.0000 |
| John | 14000.00 | 5600.0000 |
| Karen | 13500.00 | 4050.0000 |
| Alberto | 12000.00 | 3600.0000 |
| Gerald | 11000.00 | 3300.0000 |
| Eleni | 10500.00 | 2100.0000 |
| Peter | 10000.00 | 3000.0000 |
| David | 9500.00 | 2375.0000 |
| Peter | 9000.00 | 2250.0000 |
| Christopher | 8000.00 | 1600.0000 |
| Nanette | 7500.00 | 1500.0000 |
| Oliver | 7000.00 | 1050.0000 |
| Janette | 10000.00 | 3500.0000 |
| Patrick | 9500.00 | 3325.0000 |
| Allan | 9000.00 | 3150.0000 |
| Lindsey | 8000.00 | 2400.0000 |
| Louise | 7500.00 | 2250.0000 |
| Sarath | 7000.00 | 1750.0000 |
| Clara | 10500.00 | 2625.0000 |
| Danielle | 9500.00 | 1425.0000 |
| Mattea | 7200.00 | 720.0000 |
| David | 6800.00 | 680.0000 |
| Sundar | 6400.00 | 640.0000 |
| Amit | 6200.00 | 620.0000 |
| Lisa | 11500.00 | 2875.0000 |
| Harrison | 10000.00 | 2000.0000 |
| Tayler | 9600.00 | 1920.0000 |
| William | 7400.00 | 1110.0000 |
| Elizabeth | 7300.00 | 1095.0000 |
| Sundita | 6100.00 | 610.0000 |
| Ellen | 11000.00 | 3300.0000 |
| Alyssa | 8800.00 | 2200.0000 |
| Jonathon | 8600.00 | 1720.0000 |
| Jack | 8400.00 | 1680.0000 |
| Kimberely | 7000.00 | 1050.0000 |
| Charles | 6200.00 | 620.0000 |
| Winston | 3200.00 | 0.0000 |
| Jean | 3100.00 | 0.0000 |
| Martha | 2500.00 | 0.0000 |
| Girard | 2800.00 | 0.0000 |
| Nandita | 4200.00 | 0.0000 |
| Alexis | 4100.00 | 0.0000 |
| Julia | 3400.00 | 0.0000 |
| Anthony | 3000.00 | 0.0000 |
| Kelly | 3800.00 | 0.0000 |
| Jennifer | 3600.00 | 0.0000 |
| Timothy | 2900.00 | 0.0000 |
| Randall | 2500.00 | 0.0000 |
| Sarah | 4000.00 | 0.0000 |
| Britney | 3900.00 | 0.0000 |
| Samuel | 3200.00 | 0.0000 |
| Vance | 2800.00 | 0.0000 |
| Alana | 3100.00 | 0.0000 |
| Kevin | 3000.00 | 0.0000 |
| Donald | 2600.00 | 0.0000 |
 | Douglas | 2600.00 | 0.0000 |
| Jennifer | 4400.00 | 0.0000 |
| Michael | 13000.00 | 0.0000 |
| Pat | 6000.00 | 0.0000 |
| Susan | 6500.00 | 0.0000 |
| Hermann | 10000.00 | 0.0000 |
| Shelley | 12000.00 | 0.0000 |
| William | 8300.00 | 0.0000 |
+-------------+----------+-------------------+
107 rows in set (0.01 sec)
20. Write a query to display FIRST_NAME, SALARY and NET_SALARY after 500 deduction
from salary of all employees;
Query 20:
select first_name, salary , (salary - 500) as net_salary from employees;
+-------------+----------+------------+
| first_name | salary | net_salary |
+-------------+----------+------------+
| Steven | 24000.00 | 23500.00 |
| Neena | 17000.00 | 16500.00 |
| Lex | 17000.00 | 16500.00 |
| Alexander | 9000.00 | 8500.00 |
| Bruce | 6000.00 | 5500.00 |
| David | 4800.00 | 4300.00 |
| Valli | 4800.00 | 4300.00 |
| Diana | 4200.00 | 3700.00 |
| Nancy | 12000.00 | 11500.00 |
| Daniel | 9000.00 | 8500.00 |
| John | 8200.00 | 7700.00 |
| Ismael | 7700.00 | 7200.00 |
| Jose Manuel | 7800.00 | 7300.00 |
| Luis | 6900.00 | 6400.00 |
| Den | 11000.00 | 10500.00 |
| Alexander | 3100.00 | 2600.00 |
| Shelli | 2900.00 | 2400.00 |
| Sigal | 2800.00 | 2300.00 |
| Guy | 2600.00 | 2100.00 |
| Karen | 2500.00 | 2000.00 |
| Matthew | 8000.00 | 7500.00 |
| Adam | 8200.00 | 7700.00 |
| Payam | 7900.00 | 7400.00 |
| Shanta | 6500.00 | 6000.00 |
| Kevin | 5800.00 | 5300.00 |
| Julia | 3200.00 | 2700.00 |
| Irene | 2700.00 | 2200.00 |
| James | 2400.00 | 1900.00 |
| Steven | 2200.00 | 1700.00 |
| Laura | 3300.00 | 2800.00 |
| Mozhe | 2800.00 | 2300.00 |
| James | 2500.00 | 2000.00 |
| TJ | 2100.00 | 1600.00 |
| Jason | 3300.00 | 2800.00 |
| Michael | 2900.00 | 2400.00 |
| Ki | 2400.00 | 1900.00 |
| Hazel | 2200.00 | 1700.00 |
| Renske | 3600.00 | 3100.00 |
| Stephen | 3200.00 | 2700.00 |
| John | 2700.00 | 2200.00 |
| Joshua | 2500.00 | 2000.00 |
| Trenna | 3500.00 | 3000.00 |
| Curtis | 3100.00 | 2600.00 |
| Randall | 2600.00 | 2100.00 |
| Peter | 2500.00 | 2000.00 |
| John | 14000.00 | 13500.00 |
| Karen | 13500.00 | 13000.00 |
| Alberto | 12000.00 | 11500.00 |
| Gerald | 11000.00 | 10500.00 |
| Eleni | 10500.00 | 10000.00 |
| Peter | 10000.00 | 9500.00 |
| David | 9500.00 | 9000.00 |
| Peter | 9000.00 | 8500.00 |
| Christopher | 8000.00 | 7500.00 |
| Nanette | 7500.00 | 7000.00 |
| Oliver | 7000.00 | 6500.00 |
| Janette | 10000.00 | 9500.00 |
| Patrick | 9500.00 | 9000.00 |
| Allan | 9000.00 | 8500.00 |
| Lindsey | 8000.00 | 7500.00 |
| Louise | 7500.00 | 7000.00 |
| Sarath | 7000.00 | 6500.00 |
| Clara | 10500.00 | 10000.00 |
| Danielle | 9500.00 | 9000.00 |
| Mattea | 7200.00 | 6700.00 |
| David | 6800.00 | 6300.00 |
| Sundar | 6400.00 | 5900.00 |
| Amit | 6200.00 | 5700.00 |
| Lisa | 11500.00 | 11000.00 |
| Harrison | 10000.00 | 9500.00 |
| Tayler | 9600.00 | 9100.00 |
| William | 7400.00 | 6900.00 |
| Elizabeth | 7300.00 | 6800.00 |
| Sundita | 6100.00 | 5600.00 |
| Ellen | 11000.00 | 10500.00 |
| Alyssa | 8800.00 | 8300.00 |
| Jonathon | 8600.00 | 8100.00 |
| Jack | 8400.00 | 7900.00 |
| Kimberely | 7000.00 | 6500.00 |
| Charles | 6200.00 | 5700.00 |
| Winston | 3200.00 | 2700.00 |
| Jean | 3100.00 | 2600.00 |
| Martha | 2500.00 | 2000.00 |
| Girard | 2800.00 | 2300.00 |
| Nandita | 4200.00 | 3700.00 |
| Alexis | 4100.00 | 3600.00 |
| Julia | 3400.00 | 2900.00 |
| Anthony | 3000.00 | 2500.00 |
| Kelly | 3800.00 | 3300.00 |
| Jennifer | 3600.00 | 3100.00 |
| Timothy | 2900.00 | 2400.00 |
| Randall | 2500.00 | 2000.00 |
| Sarah | 4000.00 | 3500.00 |
| Britney | 3900.00 | 3400.00 |
| Samuel | 3200.00 | 2700.00 |
| Vance | 2800.00 | 2300.00 |
| Alana | 3100.00 | 2600.00 |
| Kevin | 3000.00 | 2500.00 |
| Donald | 2600.00 | 2100.00 |
| Douglas | 2600.00 | 2100.00 |
| Jennifer | 4400.00 | 3900.00 |
| Michael | 13000.00 | 12500.00 |
| Pat | 6000.00 | 5500.00 |
| Susan | 6500.00 | 6000.00 |
| Hermann | 10000.00 | 9500.00 |
| Shelley | 12000.00 | 11500.00 |
| William | 8300.00 | 7800.00 |
+-------------+----------+------------+
107 rows in set (0.00 sec)