Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

Np Ms Office 365/Excel 2016 I Ntermed
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 3.9CP
See similar textbooks
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 bought at least one product in 2015. List each customer 
only once.

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

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS