queries
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Design the SQL-statements that are used as a basis to
create the original reports and other queries that include
the following (at least):
- A SELECT using an inequality
- A SELECT using LIKE on a text field
- A SELECT on a DATE column
- A query using GROUP BY
- A query using HAVING
- A query using ORDER BY
- A query using a subquery
- A query using a correlated subquery
- A query involving COUNT(*)
- A query involving another aggregate function
- A selective DELETE
- A selective UPDATE
![Customers and Pets
CustamerID Type of Custamer Custamer Name
Street/Apt
City
State Zip Code
Phane Number Fax Number
Pet Name
PetD
Type Of Animal
Breed
DoB
Gender
АC001
2
All Creatures
21 Grace St.
Tall Pines
WA
98746
(206) 555-6622 (206) 555-7854
Bobo
AC001-01
RABBIT
Long Ear
4/8/92
M
Fido
AC001-04
DOG
German Shepherd
6/1/90
M
Presto Chango
AC001-02
LIZARD
Chameleon
5/1/92
Stinky
AC001-03
SKUNK
8/1/91
M
AD001
1
Johnathan Adams
66 10th St
Mountain View
WA
984101012
(206) 555-7623 (206) 555-8855
Patty
AD001-01
PIG
Potbelly
2/15/91
F
Rising Sun
AD001-02
HORSE
Palomino
4/1 0/90
M
AD002
1
William Adams
1122 10th St
Lakeville
OR
974011011
(503) 555-6187 (503) 555-7319
Dee Dee
AD002-01
DOG
Miked
2/15/91
F
AK001
2
Animal Kingdom
15 Marlin Lane Borderville
ID
834835646
(208) 555-7108
Jerry
AK001-03
RAT
2/1/88
M
Luigi
AK001-07
DOG
Веagle
8/1/92
M
Daily Visits Report
CustomerName
PetName
VisDate Vetainaian
ServiceD
Treament/Medication
Price
Adam Johnson
Fi Fi
5/9/99 Walters, Margaret
T1003
Lab Work - Misc
$35.00
T1001
Lab Work - Cerology
$75 00
T0300
General Exam
$50.00
M0202
Zinc Oxide - 4 oz
$7.80
Pet Total:
$16780
Customer Total:
$16780
All Creatures
Fido
11 4/9 8 Carrington, Maram
T2003
Flea Spray
$25.00
Nyostatine - 1 oz
Xaritain Glycon ol - 2 oz
MO500
$1 1. 50
MO702
$34. 50
T0404
Repair compl cz fracture
$230.00
T0408
Cast affected area
$120.00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe8260224-635c-426e-a960-28f2cf28de1f%2F55258a27-bed4-4cfa-9bac-a9f9be4d8fd4%2Fabkls5_processed.png&w=3840&q=75)
Transcribed Image Text:Customers and Pets
CustamerID Type of Custamer Custamer Name
Street/Apt
City
State Zip Code
Phane Number Fax Number
Pet Name
PetD
Type Of Animal
Breed
DoB
Gender
АC001
2
All Creatures
21 Grace St.
Tall Pines
WA
98746
(206) 555-6622 (206) 555-7854
Bobo
AC001-01
RABBIT
Long Ear
4/8/92
M
Fido
AC001-04
DOG
German Shepherd
6/1/90
M
Presto Chango
AC001-02
LIZARD
Chameleon
5/1/92
Stinky
AC001-03
SKUNK
8/1/91
M
AD001
1
Johnathan Adams
66 10th St
Mountain View
WA
984101012
(206) 555-7623 (206) 555-8855
Patty
AD001-01
PIG
Potbelly
2/15/91
F
Rising Sun
AD001-02
HORSE
Palomino
4/1 0/90
M
AD002
1
William Adams
1122 10th St
Lakeville
OR
974011011
(503) 555-6187 (503) 555-7319
Dee Dee
AD002-01
DOG
Miked
2/15/91
F
AK001
2
Animal Kingdom
15 Marlin Lane Borderville
ID
834835646
(208) 555-7108
Jerry
AK001-03
RAT
2/1/88
M
Luigi
AK001-07
DOG
Веagle
8/1/92
M
Daily Visits Report
CustomerName
PetName
VisDate Vetainaian
ServiceD
Treament/Medication
Price
Adam Johnson
Fi Fi
5/9/99 Walters, Margaret
T1003
Lab Work - Misc
$35.00
T1001
Lab Work - Cerology
$75 00
T0300
General Exam
$50.00
M0202
Zinc Oxide - 4 oz
$7.80
Pet Total:
$16780
Customer Total:
$16780
All Creatures
Fido
11 4/9 8 Carrington, Maram
T2003
Flea Spray
$25.00
Nyostatine - 1 oz
Xaritain Glycon ol - 2 oz
MO500
$1 1. 50
MO702
$34. 50
T0404
Repair compl cz fracture
$230.00
T0408
Cast affected area
$120.00
![Hospital Employees
Employee ID LastName
First Name
Educational
Hire Date Address
City
State Zip
Home Phone
Degree
2
Becker
Todd
MS.
4-Aug-92 908 W.Capital Way
Tacoma
WA
98401
(206) S55-9482
Bowie
Ros ie
B.S.
6-Mar-94
4726 - 11th Ave. N.E.
Seatle
WA
98105
(206) SSS-1189
3
Carrington
Maram
MS.
1l-Apr-92
722 Moss Bay Blvd.
Kirkland
WA
98033
(206) 555-3412
17-Oct-93
Coventy House
Mirer Rd.
6
Chu
Liu
MS.
Tacoma
WA
98402
(71) 555-73
9
Dennis
Ame
MS.
S-Nov-94
7 Hounds tooth Rd.
Bellingham
WA
98047
(71) SSS-4444
5
Peters
Peter
B.S.
17-Oct-93
14 Garett Hill
Bellingham
WA
98047
(71) 5S5-4948
1-May-92 s07- 20th Ave. E.
Apt. 2A
Edgeham Hollow
Wirches ter Way
3-May-93 4110 Old Redmond Rd.
1
Plotter
Mary
PhD.
Seatle
WA
98122
(206) 55S-9857
7
Wally
Robert
AA.
12-Jan-94
Seatle
WA
98125
(71) SSS-5598
4
Walters
Magaret
MS.
Redmond
WA
98052
(206) 555-8122](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe8260224-635c-426e-a960-28f2cf28de1f%2F55258a27-bed4-4cfa-9bac-a9f9be4d8fd4%2Ft9b12gw_processed.png&w=3840&q=75)
Transcribed Image Text:Hospital Employees
Employee ID LastName
First Name
Educational
Hire Date Address
City
State Zip
Home Phone
Degree
2
Becker
Todd
MS.
4-Aug-92 908 W.Capital Way
Tacoma
WA
98401
(206) S55-9482
Bowie
Ros ie
B.S.
6-Mar-94
4726 - 11th Ave. N.E.
Seatle
WA
98105
(206) SSS-1189
3
Carrington
Maram
MS.
1l-Apr-92
722 Moss Bay Blvd.
Kirkland
WA
98033
(206) 555-3412
17-Oct-93
Coventy House
Mirer Rd.
6
Chu
Liu
MS.
Tacoma
WA
98402
(71) 555-73
9
Dennis
Ame
MS.
S-Nov-94
7 Hounds tooth Rd.
Bellingham
WA
98047
(71) SSS-4444
5
Peters
Peter
B.S.
17-Oct-93
14 Garett Hill
Bellingham
WA
98047
(71) 5S5-4948
1-May-92 s07- 20th Ave. E.
Apt. 2A
Edgeham Hollow
Wirches ter Way
3-May-93 4110 Old Redmond Rd.
1
Plotter
Mary
PhD.
Seatle
WA
98122
(206) 55S-9857
7
Wally
Robert
AA.
12-Jan-94
Seatle
WA
98125
(71) SSS-5598
4
Walters
Magaret
MS.
Redmond
WA
98052
(206) 555-8122
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY