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
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
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 2.12CP
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
List each customer who bought at least one product in 2015. List each customer
only once.
Expert Solution
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
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning