Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
queries

queries

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
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
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
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
Step 1

As per bartleby guidelines, we can answer first 3 queries of a question. please post the rest of the queries as a separate question.

 

1. Inequality:-  any of the inequality symbols:- <> or != can be used.

2. like operator is used for character matching

 

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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…
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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS