CUSTOMER Customer Customerld - FirstName LastName StreetAddress City State ZipCode PhoneNumbe - Click to Add 1 Sally Smith 2601 Holly Court Baltimore MD 21228 4108695532 2 Karen Walters 46 Tealeaf Road Baltimore MD 21236 4102568831 3 Thomas Williams 243555 Ambermill Stree Frederick MD 21703 4 Cecilia Jamil 18 Cochoran Way Frederick MD 21702 5 Bryan Henley 1 Ocean Street Frederick MD 21705 4435109733 6 Thomas Wright 34 Ridge Road Apt. 3 Frederick MD 21702 4104512394 7 Torey 8 Sam Watson 675 Broad Street Bel Air MD 21014 4435453311 Gonzales 16 Rossville Blvd Baltimore MD 21237 7814223451 9 Robert 46 Greenwood Circle Edgemere 8 Tiger Lane, First floor Baltimore Paisley MD 21219 3016775444 10 Katura Jimenez MD 21222 11 Tammy Knott 2344 Wise Avenue Baltimore MD 21222 4107662301 12 Josh Franz 16 Silver Spring Road Baltimore MD 21236 13 Michele Savarese 501 Boston Street Baltimore MD 21224 4106753814 Owings Mills 512 Blythe Court Apt B Columbia 14 Scott O'Leary 451 Painters Mill Road MD 21117 15 Tyler Hawkins MD 21045 6175446300 16 Sonya Patel 9948 Beaver Dam Road Hunt Valley MD 21031 4432109777 17 Karen Helfrich 4 Liberty Road Randallstown MD 21133 4107665511 18 Scott Abrams 5130 Wilkens Ave Baltimore MD 21228 3012771007 19 Susan Geaney 45 Cockeysville Road, A; Hunt Valley MD 21031 4439912397 20 David lenner 675 Grand Cental Avenu Owings Mills 21117 4437664519 FLOWER Flower Itemld ItemDescription Price Click to Add 1 Red Rose Long Stem Individual 2 Red Rose Long Stem Dozen 3 Red and White Rose Bouquet $5.99 $40.99 $38.99 4 Bouquet- Roses Valentines Day $45.99 5 Bouquet- Mother's Day Small $29.99 6 Bouquet- Mother's Day Medium 7 Bouquet- Mother's Day Large 8 Bouquet -Apology-Small 9 Bouquet- Apology- Medium 10 Bouquet- Apology- Large 11 Bouquet- Birthday Mix 12 Bouquet - Holiday $49.99 $69.99 $19.99 $39.99 $99.99 $25.99 $29.99 13 Bouquet- All Occasion $29.99 14 Bouquet- All Occasion with Vase $39.99 15 Bouquet- All Occasion with Teddy Bear $39.99 16 Bouquet- All Occasion with Teddy Bear and Vase $49.99

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...
icon
Related questions
Question

Use select statements to create queries that answer the following questions. Only provide the information requested. 

Do not provide the output.  All tables are provided below

  1. List the name and price for all bouquets priced under $79.99
  2. List the first name and last name for all customers without phone numbers.
  3. List the name of all bouquets priced at $39.99 or over. 
CUSTOMER
Customer
Customerld -
FirstName
LastName
StreetAddress
City
State
ZipCode
PhoneNumbe - Click to Add
1 Sally
Smith
2601 Holly Court
Baltimore
MD
21228 4108695532
2 Karen
Walters
46 Tealeaf Road
Baltimore
MD
21236 4102568831
3 Thomas
Williams
243555 Ambermill Stree Frederick
MD
21703
4 Cecilia
Jamil
18 Cochoran Way
Frederick
MD
21702
5 Bryan
Henley
1 Ocean Street
Frederick
MD
21705 4435109733
6 Thomas
Wright
34 Ridge Road Apt. 3
Frederick
MD
21702 4104512394
7 Torey
8 Sam
Watson
675 Broad Street
Bel Air
MD
21014 4435453311
Gonzales
16 Rossville Blvd
Baltimore
MD
21237 7814223451
9 Robert
46 Greenwood Circle
Edgemere
8 Tiger Lane, First floor Baltimore
Paisley
MD
21219 3016775444
10 Katura
Jimenez
MD
21222
11 Tammy
Knott
2344 Wise Avenue
Baltimore
MD
21222 4107662301
12 Josh
Franz
16 Silver Spring Road
Baltimore
MD
21236
13 Michele
Savarese
501 Boston Street
Baltimore
MD
21224 4106753814
Owings Mills
512 Blythe Court Apt B Columbia
14 Scott
O'Leary
451 Painters Mill Road
MD
21117
15 Tyler
Hawkins
MD
21045 6175446300
16 Sonya
Patel
9948 Beaver Dam Road Hunt Valley
MD
21031 4432109777
17 Karen
Helfrich
4 Liberty Road
Randallstown MD
21133 4107665511
18 Scott
Abrams
5130 Wilkens Ave
Baltimore
MD
21228 3012771007
19 Susan
Geaney
45 Cockeysville Road, A; Hunt Valley
MD
21031 4439912397
20 David
lenner
675 Grand Cental Avenu Owings Mills
21117 4437664519
Transcribed Image Text:CUSTOMER Customer Customerld - FirstName LastName StreetAddress City State ZipCode PhoneNumbe - Click to Add 1 Sally Smith 2601 Holly Court Baltimore MD 21228 4108695532 2 Karen Walters 46 Tealeaf Road Baltimore MD 21236 4102568831 3 Thomas Williams 243555 Ambermill Stree Frederick MD 21703 4 Cecilia Jamil 18 Cochoran Way Frederick MD 21702 5 Bryan Henley 1 Ocean Street Frederick MD 21705 4435109733 6 Thomas Wright 34 Ridge Road Apt. 3 Frederick MD 21702 4104512394 7 Torey 8 Sam Watson 675 Broad Street Bel Air MD 21014 4435453311 Gonzales 16 Rossville Blvd Baltimore MD 21237 7814223451 9 Robert 46 Greenwood Circle Edgemere 8 Tiger Lane, First floor Baltimore Paisley MD 21219 3016775444 10 Katura Jimenez MD 21222 11 Tammy Knott 2344 Wise Avenue Baltimore MD 21222 4107662301 12 Josh Franz 16 Silver Spring Road Baltimore MD 21236 13 Michele Savarese 501 Boston Street Baltimore MD 21224 4106753814 Owings Mills 512 Blythe Court Apt B Columbia 14 Scott O'Leary 451 Painters Mill Road MD 21117 15 Tyler Hawkins MD 21045 6175446300 16 Sonya Patel 9948 Beaver Dam Road Hunt Valley MD 21031 4432109777 17 Karen Helfrich 4 Liberty Road Randallstown MD 21133 4107665511 18 Scott Abrams 5130 Wilkens Ave Baltimore MD 21228 3012771007 19 Susan Geaney 45 Cockeysville Road, A; Hunt Valley MD 21031 4439912397 20 David lenner 675 Grand Cental Avenu Owings Mills 21117 4437664519
FLOWER
Flower
Itemld
ItemDescription
Price
Click to Add
1 Red Rose Long Stem Individual
2 Red Rose Long Stem Dozen
3 Red and White Rose Bouquet
$5.99
$40.99
$38.99
4 Bouquet- Roses Valentines Day
$45.99
5 Bouquet- Mother's Day Small
$29.99
6 Bouquet- Mother's Day Medium
7 Bouquet- Mother's Day Large
8 Bouquet -Apology-Small
9 Bouquet- Apology- Medium
10 Bouquet- Apology- Large
11 Bouquet- Birthday Mix
12 Bouquet - Holiday
$49.99
$69.99
$19.99
$39.99
$99.99
$25.99
$29.99
13 Bouquet- All Occasion
$29.99
14 Bouquet- All Occasion with Vase
$39.99
15 Bouquet- All Occasion with Teddy Bear
$39.99
16 Bouquet- All Occasion with Teddy Bear and Vase
$49.99
Transcribed Image Text:FLOWER Flower Itemld ItemDescription Price Click to Add 1 Red Rose Long Stem Individual 2 Red Rose Long Stem Dozen 3 Red and White Rose Bouquet $5.99 $40.99 $38.99 4 Bouquet- Roses Valentines Day $45.99 5 Bouquet- Mother's Day Small $29.99 6 Bouquet- Mother's Day Medium 7 Bouquet- Mother's Day Large 8 Bouquet -Apology-Small 9 Bouquet- Apology- Medium 10 Bouquet- Apology- Large 11 Bouquet- Birthday Mix 12 Bouquet - Holiday $49.99 $69.99 $19.99 $39.99 $99.99 $25.99 $29.99 13 Bouquet- All Occasion $29.99 14 Bouquet- All Occasion with Vase $39.99 15 Bouquet- All Occasion with Teddy Bear $39.99 16 Bouquet- All Occasion with Teddy Bear and Vase $49.99
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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