Pos 410 Week 3 Sql Homework
Essay by review • January 1, 2011 • Study Guide • 10,068 Words (41 Pages) • 3,577 Views
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 |
| Meier | Elaine | Non Exempt | 20500 |
| Meier | Elaine | Non Exempt | 20500 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Nguyen | Meridith | Exempt | 43000 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Nguyen | Meridith | Exempt | 43000 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Nguyen | Meridith | Non Exempt | 43000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Quillian | Stanley | Exempt | 23000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Quillian | Stanley | Exempt | 23000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Quillian | Stanley | Non Exempt | 23000 |
| Sharp | Nancy | Non Exempt | 21000 |
| Sharp | Nancy | Exempt | 21000 |
...
...
(2011, 01). Pos 410 Week 3 Sql Homework. ReviewEssays.com. Retrieved 01, 2011, from https://www.reviewessays.com/essay/Pos-410-Week-3-Sql-Homework/28788.html
"Pos 410 Week 3 Sql Homework" ReviewEssays.com. 01 2011. 2011. 01 2011 <https://www.reviewessays.com/essay/Pos-410-Week-3-Sql-Homework/28788.html>.
"Pos 410 Week 3 Sql Homework." ReviewEssays.com. ReviewEssays.com, 01 2011. Web. 01 2011. <https://www.reviewessays.com/essay/Pos-410-Week-3-Sql-Homework/28788.html>.
"Pos 410 Week 3 Sql Homework." ReviewEssays.com. 01, 2011. Accessed 01, 2011. https://www.reviewessays.com/essay/Pos-410-Week-3-Sql-Homework/28788.html.