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 Walnut