|
Title: POS 410 Week 3 SQL Homework
Essay Details
| Subject: |
Technology |
| Author: |
|
| Date: |
February 4, 1998 |
| Level: |
|
| Grade: |
|
| Length: |
12 / 3277 |
| No of views: |
0 |
| Essay rating: |
good 0,
average 0,
bad 0
(total score: 0)
|
Essay text:
***Between Select Statement***
Select Last_name, First_name, Job_title , Hire_date
From employee, Job_title
Where Hire_date between '2000-01-01' and '2005-01-01';
mysql> Select Last_name, First_name, Job_title , Hire_date
-> From employee, Job_title
-> Where Hire_date between '2000-01-01' and '2005-01-01';
+-----------+------------+---------------------------------------------------+------------+
| Last_name | First_name | Job_title | Hire_date |
+-----------+------------+---------------------------------------------------+------------+
| Avery | Ledonna | Accounting Clerk | 2003-03-28 |
| Avery | Ledonna | Assistant Manager | 2003-03-28 |
| Avery | Ledonna | Bagger | 2003-03-28 |
| Avery | Ledonna | Cashier | 2003-03-28 |
| Avery | Ledonna | Computer Support Specialist | 2003-03-28 |
| Avery | Ledonna | Director of Finance and Accounting | 2003-03-28 |
| Avery | Ledonna | Retail Assistant Bakery and Pastry | 2003-03-28 |
| Avery | Ledonna | Retail Assistant butchers and Seafood Specialists | 2003-03-28 |
| Avery | Ledonna | Stocker | 2003-03-28 |
| Broun | Erin | Accounting Clerk | 2003-03-12 |
| Broun | Erin | Assistant Manager | 2003-03-12 |
| Broun | Erin | Bagger | 2003-03-12 |
| Broun | Erin | Cashier | 2003-03-12 |
| Broun | Erin | Computer Support Specialist | 2003-03-12 |
| Broun | Erin | Director of Finance and Accounting | 2003-03-12 |
| Broun | Erin | Retail Assistant Bakery and Pastry | 2003-03-12 |
| Broun | Erin | Retail Assistant butchers and Seafood Specialists | 2003-03-12 |
| Broun | Erin | Stocker | 2003-03-12 |
| Carpenter | Donald | Accounting Clerk | 2003-11-01 |
| Carpenter | Donald | Assistant Manager | 2003-11-01 |
| Carpenter | Donald | Bagger | 2003-11-01 |
| Carpenter | Donald | Cashier | 2003-11-01 |
| Carpenter | Donald | Computer Support Specialist | 2003-11-01 |
| Carpenter | Donald | Director of Finance and Accounting | 2003-11-01 |
| Carpenter | Donald | Retail Assistant Bakery and Pastry | 2003-11-01 |
| Carpenter | Donald | Retail Assistant butchers and Seafood Specialists | 2003-11-01 |
| Carpenter | Donald | Stocker | 2003-11-01 |
| Drohos | Craig | Accounting Clerk | 2000-06-15 |
| Drohos | Craig | Assistant Manager | 2000-06-15 |
| Drohos | Craig | Bagger | 2000-06-15 |
| Drohos | Craig | Cashier | 2000-06-15 |
| Drohos | Craig | Computer Support Specialist | 2000-06-15 |
| Drohos | Craig | Director of Finance and Accounting | 2000-06-15 |
| Drohos | Craig | Retail Assistant Bakery and Pastry | 2000-06-15 |
| Drohos | Craig | Retail Assistant butchers and Seafood Specialists | 2000-06-15 |
| Drohos | Craig | Stocker | 2000-06-15 |
| Edelman | Glenn | Accounting Clerk | 2003-10-07 |
| Edelman | Glenn | Assistant Manager | 2003-10-07 |
| Edelman | Glenn | Bagger | 2003-10-07 |
| Edelman | Glenn | Cashier | 2003-10-07 |
| Edelman | Glenn | Computer Support Specialist | 2003-10-07 |
| Edelman | Glenn | Director of Finance and Accounting | 2003-10-07 |
| Edelman | Glenn | Retail Assistant Bakery and Pastry | 2003-10-07 |
| Edelman | Glenn | Retail Assistant butchers and Seafood Specialists | 2003-10-07 |
| Edelman | Glenn | Stocker | 2003-10-07 |
| Esquivez | David | Accounting Clerk | 2003-07-25 |
| Esquivez | David | Assistant Manager | 2003-07-25 |
| Esquivez | David | Bagger | 2003-07-25 |
| Esquivez | David | Cashier | 2003-07-25 |
| Esquivez | David | Computer Support Specialist | 2003-07-25 |
| Esquivez | David | Director of Finance and Accounting | 2003-07-25 |
| Esquivez | David | Retail Assistant Bakery and Pastry | 2003-07-25 |
| Esquivez | David | Retail Assistant butchers and Seafood Specialists | 2003-07-25 |
| Esquivez | David | Stocker | 2003-07-25 |
| McMullen | Eric | Accounting Clerk | 2002-11-01 |
| McMullen | Eric | Assistant Manager | 2002-11-01 |
| McMullen | Eric | Bagger | 2002-11-01 |
| McMullen | Eric | Cashier | 2002-11-01 |
| McMullen | Eric | Computer Support Specialist | 2002-11-01 |
| McMullen | Eric | Director of Finance and Accounting | 2002-11-01 |
| McMullen | Eric | Retail Assistant Bakery and Pastry | 2002-11-01 |
| McMullen | Eric | Retail Assistant butchers and Seafood Specialists | 2002-11-01 |
| McMullen | Eric | Stocker | 2002-11-01 |
| Meier | Elaine | Accounting Clerk | 2000-09-10 |
| Meier | Elaine | Assistant Manager | 2000-09-10 |
| Meier | Elaine | Bagger | 2000-09-10 |
| Meier | Elaine | Cashier | 2000-09-10 |
| Meier | Elaine | Computer Support Specialist | 2000-09-10 |
| Meier | Elaine | Director of Finance and Accounting | 2000-09-10 |
| Meier | Elaine | Retail Assistant Bakery and Pastry | 2000-09-10 |
| Meier | Elaine | Retail Assistant butchers and Seafood Specialists | 2000-09-10 |
| Meier | Elaine | Stocker | 2000-09-10 |
| Sharp | Nancy | Accounting Clerk | 2003-07-12 |
| Sharp | Nancy | Assistant Manager | 2003-07-12 |
| Sharp | Nancy | Bagger | 2003-07-12 |
| Sharp | Nancy | Cashier | 2003-07-12 |
| Sharp | Nancy | Computer Support Specialist | 2003-07-12 |
| Sharp | Nancy | Director of Finance and Accounting | 2003-07-12 |
| Sharp | Nancy | Retail Assistant Bakery and Pastry | 2003-07-12 |
| Sharp | Nancy | Retail Assistant butchers and Seafood Specialists | 2003-07-12 |
| Sharp | Nancy | Stocker | 2003-07-12 |
| Tyink | Thomas | Accounting Clerk | 2001-05-01 |
| Tyink | Thomas | Assistant Manager | 2001-05-01 |
| Tyink | Thomas | Bagger | 2001-05-01 |
| Tyink | Thomas | Cashier | 2001-05-01 |
| Tyink | Thomas | Computer Support Specialist | 2001-05-01 |
| Tyink | Thomas | Director of Finance and Accounting | 2001-05-01 |
| Tyink | Thomas | Retail Assistant Bakery and Pastry | 2001-05-01 |
| Tyink | Thomas | Retail Assistant butchers and Seafood Specialists | 2001-05-01 |
| Tyink | Thomas | Stocker | 2001-05-01 |
| Vance | Brent | Accounting Clerk | 2001-03-29 |
| Vance | Brent | Assistant Manager | 2001-03-29 |
| Vance | Brent | Bagger | 2001-03-29 |
| Vance | Brent | Cashier | 2001-03-29 |
| Vance | Brent | Computer Support Specialist | 2001-03-29 |
| Vance | Brent | Director of Finance and Accounting | 2001-03-29 |
| Vance | Brent | Retail Assistant Bakery and Pastry | 2001-03-29 |
| Vance | Brent | Retail Assistant butchers and Seafood Specialists | 2001-03-29 |
| Vance | Brent | Stocker | 2001-03-29 |
+-----------+------------+---------------------------------------------------+------------+
99 rows in set (0...
Showed first 250 characters
|
|
 |
Pay for FULL access
Gives you access immediately to all 184 990 essays.
You get access to all the essays. You can view as many as you like.
As little as 14 cents/day! |
|
|
|
Submit essays
Takes from 3 to 7 days, before your essays get reviewed.
You must submit for review:
1 essay to get limited access
3 essays to get full access
Figure out how to submit essays. |
|
 |
|
|
|
***Between Select Statement***
Select Last_name, First_name, Job_title , Hire_date
From employee, Job_title
Where Hire_date between '2000-01-01' and '2005-01-01';
mysql> Select Last_name, First_name, Job_title , Hire_date
-> From employee, Job_title
-> Where Hire_date between '2000-01-01' and '2005-01-01';
+-----------+------------+---------------------------------------------------+------------+
| Last_name | First_name | Job_title | Hire_date |
+-----------+------------+---------------------------------------------------+------------+
| Avery | Ledonna | Accounting Clerk | 2003-03-28 |
| Avery | Ledonna | Assistant Manager | 2003-03-28 |
| Avery | Ledonna | Bagger | 2003-03-28 |
| Avery | Ledonna | Cashier | 2003-03-28 |
| Avery | Ledonna | Computer Support Specialist | 2003-03-28 |
| Avery | Ledonna | Director of Finance and Accounting | 2003-03-28 |
| Avery | Ledonna | Retail Assistant Bakery and Pastry | 2003-03-28 |
| Avery | Ledonna | Retail Assistant butchers and Seafood Specialists | 2003-03-28 |
| Avery | Ledonna | Stocker | 2003-03-28 |
| Broun | Erin | Accounting Clerk | 2003-03-12 |
| Broun | Erin | Assistant Manager | 2003-03-12 |
| Broun | Erin | Bagger | 2003-03-12 |
| Broun | Erin | Cashier | 2003-03-12 |
| Broun | Erin | Computer Support Specialist | 2003-03-12 |
| Broun | Erin | Director of Finance and Accounting | 2003-03-12 |
| Broun | Erin | Retail Assistant Bakery and Pastry | 2003-03-12 |
| Broun | Erin | Retail Assistant butchers and Seafood Specialists | 2003-03-12 |
| Broun | Erin | Stocker | 2003-03-12 |
| Carpenter | Donald | Accounting Clerk | 2003-11-01 |
| Carpenter | Donald | Assistant Manager | 2003-11-01 |
| Carpenter | Donald | Bagger | 2003-11-01 |
| Carpenter | Donald | Cashier | 2003-11-01 |
| Carpenter | Donald | Computer Support Specialist | 2003-11-01 |
| Carpenter | Donald | Director of Finance and Accounting | 2003-11-01 |
| Carpenter | Donald | Retail Assistant Bakery and Pastry | 2003-11-01 |
| Carpenter | Donald | Retail Assistant butchers and Seafood Specialists | 2003-11-01 |
| Carpenter | Donald | Stocker | 2003-11-01 |
| Drohos | Craig | Accounting Clerk | 2000-06-15 |
| Drohos | Craig | Assistant Manager | 2000-06-15 |
| Drohos | Craig | Bagger | 2000-06-15 |
| Drohos | Craig | Cashier | 2000-06-15 |
| Drohos | Craig | Computer Support Specialist | 2000-06-15 |
| Drohos | Craig | Director of Finance and Accounting | 2000-06-15 |
| Drohos | Craig | Retail Assistant Bakery and Pastry | 2000-06-15 |
| Drohos | Craig | Retail Assistant butchers and Seafood Specialists | 2000-06-15 |
| Drohos | Craig | Stocker | 2000-06-15 |
| Edelman | Glenn | Accounting Clerk | 2003-10-07 |
| Edelman | Glenn | Assistant Manager | 2003-10-07 |
| Edelman | Glenn | Bagger | 2003-10-07 |
| Edelman | Glenn | Cashier | 2003-10-07 |
| Edelman | Glenn | Computer Support Specialist | 2003-10-07 |
| Edelman | Glenn | Director of Finance and Accounting | 2003-10-07 |
| Edelman | Glenn | Retail Assistant Bakery and Pastry | 2003-10-07 |
| Edelman | Glenn | Retail Assistant butchers and Seafood Specialists | 2003-10-07 |
| Edelman | Glenn | Stocker | 2003-10-07 |
| Esquivez | David | Accounting Clerk | 2003-07-25 |
| Esquivez | David | Assistant Manager | 2003-07-25 |
| Esquivez | David | Bagger | 2003-07-25 |
| Esquivez | David | Cashier | 2003-07-25 |
| Esquivez | David | Computer Support Specialist | 2003-07-25 |
| Esquivez | David | Director of Finance and Accounting | 2003-07-25 |
| Esquivez | David | Retail Assistant Bakery and Pastry | 2003-07-25 |
| Esquivez | David | Retail Assistant butchers and Seafood Specialists | 2003-07-25 |
| Esquivez | David | Stocker | 2003-07-25 |
| McMullen | Eric | Accounting Clerk | 2002-11-01 |
| McMullen | Eric | Assistant Manager | 2002-11-01 |
| McMullen | Eric | Bagger | 2002-11-01 |
| McMullen | Eric | Cashier | 2002-11-01 |
| McMullen | Eric | Computer Support Specialist | 2002-11-01 |
| McMullen | Eric | Director of Finance and Accounting | 2002-11-01 |
| McMullen | Eric | Retail Assistant Bakery and Pastry | 2002-11-01 |
| McMullen | Eric | Retail Assistant butchers and Seafood Specialists | 2002-11-01 |
| McMullen | Eric | Stocker | 2002-11-01 |
| Meier | Elaine | Accounting Clerk | 2000-09-10 |
| Meier | Elaine | Assistant Manager | 2000-09-10 |
| Meier | Elaine | Bagger | 2000-09-10 |
| Meier | Elaine | Cashier | 2000-09-10 |
| Meier | Elaine | Computer Support Specialist | 2000-09-10 |
| Meier | Elaine | Director of Finance and Accounting | 2000-09-10 |
| Meier | Elaine | Retail Assistant Bakery and Pastry | 2000-09-10 |
| Meier | Elaine | Retail Assistant butchers and Seafood Specialists | 2000-09-10 |
| Meier | Elaine | Stocker | 2000-09-10 |
| Sharp | Nancy | Accounting Clerk | 2003-07-12 |
| Sharp | Nancy | Assistant Manager | 2003-07-12 |
| Sharp | Nancy | Bagger | 2003-07-12 |
| Sharp | Nancy | Cashier | 2003-07-12 |
| Sharp | Nancy | Computer Support Specialist | 2003-07-12 |
| Sharp | Nancy | Director of Finance and Accounting | 2003-07-12 |
| Sharp | Nancy | Retail Assistant Bakery and Pastry | 2003-07-12 |
| Sharp | Nancy | Retail Assistant butchers and Seafood Specialists | 2003-07-12 |
| Sharp | Nancy | Stocker | 2003-07-12 |
| Tyink | Thomas | Accounting Clerk | 2001-05-01 |
| Tyink | Thomas | Assistant Manager | 2001-05-01 |
| Tyink | Thomas | Bagger | 2001-05-01 |
| Tyink | Thomas | Cashier | 2001-05-01 |
| Tyink | Thomas | Computer Support Specialist | 2001-05-01 |
| Tyink | Thomas | Director of Finance and Accounting | 2001-05-01 |
| Tyink | Thomas | Retail Assistant Bakery and Pastry | 2001-05-01 |
| Tyink | Thomas | Retail Assistant butchers and Seafood Specialists | 2001-05-01 |
| Tyink | Thomas | Stocker | 2001-05-01 |
| Vance | Brent | Accounting Clerk | 2001-03-29 |
| Vance | Brent | Assistant Manager | 2001-03-29 |
| Vance | Brent | Bagger | 2001-03-29 |
| Vance | Brent | Cashier | 2001-03-29 |
| Vance | Brent | Computer Support Specialist | 2001-03-29 |
| Vance | Brent | Director of Finance and Accounting | 2001-03-29 |
| Vance | Brent | Retail Assistant Bakery and Pastry | 2001-03-29 |
| Vance | Brent | Retail Assistant butchers and Seafood Specialists | 2001-03-29 |
| Vance | Brent | Stocker | 2001-03-29 |
+-----------+------------+---------------------------------------------------+------------+
99 rows in set (0...
Showed next 250 characters
Common topics in this essay:
Comments:
Similar Essays:
| Title |
Pages / Words |
Save |
Physician Assistant
health care team who, with doctors, provide quality care to patients. In order to do that,
training, hard work, and a good education are required.
I... |
3 / 803 |
 |
Education
Importance of Education among Health Care Professionals
Health care is one of the fastest growing industries in United States, which contributes to the largest number of employment today... |
3 / 763 |
|
Physicians
The first medical field I’ve researched are physicians. Physicians play a large role in society today, covering almost every department in the medical world... |
3 / 589 |
|
Field Report
INTRODUCTION
Today, physician assistants function as the doctor's right-hand man(or woman), backup, or in some cases, their substitute. Sometimes I wonder what the difference between a physician assistant and a doctor really is... |
6 / 1494 |
|
PTA Assistant
Physical therapist assistants and aides perform components of physical therapy procedures and related tasks selected by a supervising physical therapist, the nature of the work... |
4 / 962 |
|
MD
Secondary care
Tertiary care
In medicine, primary care is a term used for a health care provider who acts as a first point of consultation for all patients... |
2 / 312 |
|
healthcasre communication
Once common in medical practice was building a good rapport between physicians and patients, but thanks to managed care's toll on physician's time and resources, is now almost obsolete... |
2 / 377 |
|
|
|
|
