Pos 410 Week 3 Sql Homework
By: Jessica • Study Guide • 10,068 Words • June 8, 2010 • 1,775 Views
Pos 410 Week 3 Sql Homework
POS 410 SQL for Business for UOP
Assignment for Week 3 of course
1. ***Between Select Statement***
Select Last_name, First_name, Exemption_Status, Salary
From employee, Job_title
Where Salary between 20000 and 65500;
mysql> Select Last_name, First_name, Exemption_Status, Salary
-> From employee, Job_title
-> Where Salary between 20000 and 65500;
+-----------+------------+------------------+--------+
| Last_name | First_name | Exemption_Status | Salary |
+-----------+------------+------------------+--------+
| Avery | Ledonna | Non Exempt | 21000 |
| Avery | Ledonna | Exempt | 21000 |
| Avery | Ledonna | Non Exempt | 21000 |
| Avery | Ledonna | Non Exempt | 21000 |
| Avery | Ledonna | Non Exempt | 21000 |
| Avery | Ledonna | Exempt | 21000 |
| Avery | Ledonna | Non Exempt | 21000 |
| Avery | Ledonna | Non Exempt | 21000 |
| Avery | Ledonna | Non Exempt | 21000 |
| Drohos | Craig | Non Exempt | 51000 |
| Drohos | Craig | Exempt | 51000 |
| Drohos | Craig | Non Exempt | 51000 |
| Drohos | Craig | Non Exempt | 51000 |
| Drohos | Craig | Non Exempt | 51000 |
| Drohos | Craig | Exempt | 51000 |
| Drohos | Craig | Non Exempt | 51000 |
| Drohos | Craig | Non Exempt | 51000 |
| Drohos | Craig | Non Exempt | 51000 |
| Edelman | Glenn | Non Exempt | 21500 |
| Edelman | Glenn | Exempt | 21500 |
| Edelman | Glenn | Non Exempt | 21500 |
| Edelman | Glenn | Non Exempt | 21500 |
| Edelman | Glenn | Non Exempt | 21500 |
| Edelman | Glenn | Exempt | 21500 |
| Edelman | Glenn | Non Exempt | 21500 |
| Edelman | Glenn | Non Exempt | 21500 |
| Edelman | Glenn | Non Exempt | 21500 |
| McNamara | Juanita | Non Exempt | 25500 |
| McNamara | Juanita | Exempt | 25500 |
| McNamara | Juanita | Non Exempt | 25500 |
| McNamara | Juanita | Non Exempt | 25500 |
| McNamara | Juanita | Non Exempt | 25500 |
| McNamara | Juanita | Exempt | 25500 |
| McNamara | Juanita | Non Exempt | 25500 |
| McNamara | Juanita | Non Exempt | 25500 |
| McNamara | Juanita | Non Exempt | 25500 |
| Meier | Elaine | Non Exempt | 20500 |
| Meier | Elaine | Exempt | 20500 |
| Meier | Elaine | Non Exempt | 20500 |
| Meier | Elaine | Non Exempt | 20500 |
| Meier | Elaine | Non Exempt | 20500 |
| Meier | Elaine | Exempt | 20500 |
| Meier | Elaine | Non Exempt | 20500 |
|