Question
1. Assume product line names are unique. List the ids, descriptions, and prices of the products in the Scandinavia product line that cost at least
1. Assume product line names are unique. List the ids, descriptions, and prices of the products
in the Scandinavia product line that cost at least $850
.Use the join facility to answer this question; do not use subqueries.
2. List the ids, descriptions, and prices of the products in the Scandinavia product line that cost at least $750 and
have a Walnut finish
.Use the join facility to answer this
question; do not use subqueries.
3. List the order numbers and product ids, descriptions, and prices of the products ordered
from 2008 -11-05 to 2008-12-05.
Use the join facility to answer this question; do not use subqueries
4. Assume customer names are unique. List the product ids, descriptions, and prices of
the products that customer, Contemporary Casuals ordered in the month of November in 2008
.Use the join facility to answer this question; do not use
subqueries
Below is the Table:
Answer Set Answer Set X Product_Line_ID Product_Line_Name Product_ID Product_Description Product_Finish Standard_Price Product_Line_ID 1 Cherry Tree 1 Cherry Tree 1 Cherry Tree 1 Cherry Tree 1 Cherry Tree 1 Cherry Tree 1 Cherry Tree 1 Cherry Tree 3 Country Look 3 Country Look 3 Country Look 3 Country Look 3 Country Look 3 Country Look 3 Country Look 3 Country Look 2 Scandinavia 2 Scandinavia 2 Scandinavia 2 Scandinavia 2 Scandinavia 2 Scandinavia 2 Scandinavia 2 Scandinavia 6 8-Drawer Desk 3 Computer Desk 7 Dining Table 4 Entertainment Center Natural Maple 5 Writers Desk 1 End Table 2 Coffe Table 8 Computer Desk 6 8-Drawer Desk 3 Computer Desk 7 Dining Table 4 Entertainment Center Natural Maple 5 Writers Desk 1 End Table 2 Coffe Table 8 Computer Desk 6 8-Drawer Desk 3 Computer Desk 7 Dining Table 4 Entertainment Center Natural Maple 5 Writers Desk 1 End Table 2 Coffe Table 8 Computer Desk 750.0000 375.0000 800.0000 650.0000 325.0000 175.0000 200.0000 250.0000 750.0000 375.0000 800.0000 650.0000 325.0000 175.0000 200.0000 250.0000 750.0000 375.0000 800.0000 650.0000 325.0000 175.0000 200.0000 250.0000 White Ash Natural Ash Natural Ash Natural Ash Walnut White Ash Natural Ash Natural Ash Natural Ash Walnut White Ash Natural Ash Natural Ash Natural Ash WalnutStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started