CUSTOMER CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode 1 Contemporary 1355 S Hines FL Gainesville 32601-2871 Casuals Blvd 2 Value Furniture 15145 S.W. Plaro TX 75094-7743 3 Home 17th St 1900 Allard Albany NY 12209-1125 Furnishings Ave. 4 Eastern Furniture 1925 Beltline Carteret NJ 07006-3188 Rd. 1 5 Impressions 5585 Westcott Sacramento CA 94206-4066 Ct. 6 Furniture 325 Flatiron Dr. Boulder CO 80514-4432 Gallery 7 Period 394 Rainbow Seattle WA 97954-5589 Furniture Dr. 8 Califomia 816 Peach Rd. Santa Clara CA 98915-7754 Classics 9 M and H Casual 3709 First Street Clearwater FL 34620-2314 Furniture 10 Seminole 2400 Rocky Seminole FL 34646-4423 Interiors Point Dr. 11 American 2424 Missouri Prospect NJ 07508-5621 Euro Lifestyles Ave N. Park 12 Battle Creek 345 Capitol Battle Creek M 49015-3401 Furniture 13 Heritage Ave. SW 66789 Colege Carlisle PA 17013-8834 Furnishings Ave. 14 Kaneohe 112 Kiowal St. Kaneohe HI 96744-2537 Homes 15 Mountain 4132 Main Ogden UT 84403-4432 Scenes Street ORDER OrderID OrderDate Customer l 1001 21/Oct/15 1 1002 21/Oct/15 B 1003 22/Oct/15 15 1004 22/Oct/15 5 1006 24/Oct/15 3 1006 24/Oct/15 2 1007 27/Oct/15 11 1008 30/Oct/15 12 1009 05/Now/15 1010 06/Nov/15 4 1 ORDERLINE Order ID ProductID Ordered Quality 1001 1 2 1001 2 2 1001 4 1 1002 3 5 1003 3 3 1004 6 2 1004 8 2 1005 4 4 1006 4 1006 5 2 1006 7 2 1007 1 3 1007 2 2 1008 3 3 1008 8 3 1009 4 2 1009 7 3 1010 8 10 PRODUCT Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID 1 2 End Table Coffee Table Natural Ash Cherry 175 1 200 2 3 Computer Desk | Natural Ash 375 2 4 Entertainment Natural 650 3 Center Maple 5 Writers Desk Cherry 325 1 B 8-Drawer Desk White Ash 750 2 7 Dining Table Natural Ash 800 2 B Computer Desk Walnut 250 3

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 2.12CP
icon
Related questions
Question

Solve the following queries in SQL. For each query, you need to 
specify the SQL and show the result of each query if applied to the FURNITURE Database.

List each customer who has bought computer desks and the number of units 
bought by each customer.

CUSTOMER
CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode
1 Contemporary
1355 S Hines
FL
Gainesville
32601-2871
Casuals
Blvd
2
Value
Furniture
15145 S.W.
Plaro
TX
75094-7743
3
Home
17th St
1900 Allard
Albany
NY
12209-1125
Furnishings
Ave.
4
Eastern
Furniture
1925 Beltline
Carteret
NJ
07006-3188
Rd.
1
5
Impressions 5585 Westcott Sacramento
CA
94206-4066
Ct.
6
Furniture 325 Flatiron Dr.
Boulder
CO
80514-4432
Gallery
7
Period
394 Rainbow
Seattle
WA
97954-5589
Furniture
Dr.
8
Califomia
816 Peach Rd. Santa Clara
CA
98915-7754
Classics
9
M and H
Casual
3709 First
Street
Clearwater
FL
34620-2314
Furniture
10
Seminole
2400 Rocky
Seminole
FL
34646-4423
Interiors
Point Dr.
11
American
2424 Missouri
Prospect
NJ
07508-5621
Euro
Lifestyles
Ave N.
Park
12
Battle Creek
345 Capitol Battle Creek
M
49015-3401
Furniture
13
Heritage
Ave. SW
66789 Colege
Carlisle
PA
17013-8834
Furnishings
Ave.
14
Kaneohe
112 Kiowal St.
Kaneohe
HI
96744-2537
Homes
15
Mountain
4132 Main
Ogden
UT
84403-4432
Scenes
Street
ORDER
OrderID OrderDate Customer l
1001 21/Oct/15
1
1002 21/Oct/15
B
1003 22/Oct/15
15
1004 22/Oct/15
5
1006 24/Oct/15
3
1006 24/Oct/15
2
1007 27/Oct/15
11
1008 30/Oct/15
12
1009 05/Now/15
1010 06/Nov/15
4
1
Transcribed Image Text:CUSTOMER CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode 1 Contemporary 1355 S Hines FL Gainesville 32601-2871 Casuals Blvd 2 Value Furniture 15145 S.W. Plaro TX 75094-7743 3 Home 17th St 1900 Allard Albany NY 12209-1125 Furnishings Ave. 4 Eastern Furniture 1925 Beltline Carteret NJ 07006-3188 Rd. 1 5 Impressions 5585 Westcott Sacramento CA 94206-4066 Ct. 6 Furniture 325 Flatiron Dr. Boulder CO 80514-4432 Gallery 7 Period 394 Rainbow Seattle WA 97954-5589 Furniture Dr. 8 Califomia 816 Peach Rd. Santa Clara CA 98915-7754 Classics 9 M and H Casual 3709 First Street Clearwater FL 34620-2314 Furniture 10 Seminole 2400 Rocky Seminole FL 34646-4423 Interiors Point Dr. 11 American 2424 Missouri Prospect NJ 07508-5621 Euro Lifestyles Ave N. Park 12 Battle Creek 345 Capitol Battle Creek M 49015-3401 Furniture 13 Heritage Ave. SW 66789 Colege Carlisle PA 17013-8834 Furnishings Ave. 14 Kaneohe 112 Kiowal St. Kaneohe HI 96744-2537 Homes 15 Mountain 4132 Main Ogden UT 84403-4432 Scenes Street ORDER OrderID OrderDate Customer l 1001 21/Oct/15 1 1002 21/Oct/15 B 1003 22/Oct/15 15 1004 22/Oct/15 5 1006 24/Oct/15 3 1006 24/Oct/15 2 1007 27/Oct/15 11 1008 30/Oct/15 12 1009 05/Now/15 1010 06/Nov/15 4 1
ORDERLINE
Order ID
ProductID
Ordered Quality
1001
1
2
1001
2
2
1001
4
1
1002
3
5
1003
3
3
1004
6
2
1004
8
2
1005
4
4
1006
4
1006
5
2
1006
7
2
1007
1
3
1007
2
2
1008
3
3
1008
8
3
1009
4
2
1009
7
3
1010
8
10
PRODUCT
Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID
1
2
End Table
Coffee Table Natural Ash
Cherry
175
1
200
2
3
Computer Desk | Natural Ash
375
2
4
Entertainment
Natural
650
3
Center
Maple
5
Writers Desk
Cherry
325
1
B
8-Drawer Desk
White Ash
750
2
7
Dining Table Natural Ash
800
2
B Computer Desk
Walnut
250
3
Transcribed Image Text:ORDERLINE Order ID ProductID Ordered Quality 1001 1 2 1001 2 2 1001 4 1 1002 3 5 1003 3 3 1004 6 2 1004 8 2 1005 4 4 1006 4 1006 5 2 1006 7 2 1007 1 3 1007 2 2 1008 3 3 1008 8 3 1009 4 2 1009 7 3 1010 8 10 PRODUCT Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID 1 2 End Table Coffee Table Natural Ash Cherry 175 1 200 2 3 Computer Desk | Natural Ash 375 2 4 Entertainment Natural 650 3 Center Maple 5 Writers Desk Cherry 325 1 B 8-Drawer Desk White Ash 750 2 7 Dining Table Natural Ash 800 2 B Computer Desk Walnut 250 3
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning