(Solved) : Exercise 1 Create Following Product Table Productid Name Color Listprice Adjustable Race H Q36689778 . . .
data base
Exercise 1: Create the following Product Table ProductID Name Color ListPrice Adjustable Race Headset Ball Bearings Blade NULL NULT 0,00 o, 00 0, 00 316 NULL 997 998 Road-750 blu@ # 44 Road-750 Black, 48 Road-750 Black, 52 blue Black Black 11, 55 539, 99 39,99 Exercise 2: Write a query that retrieves the columns ProductID, Name, Color and ListPrice from the Product table Exercise3 Continue to work with the previous query and exclude those rows that are 0 for the column ListPrice. Your result set should look something like the following. ProductID Name Color ListPrice 997 998 Road-750 blue44 Road-750 Black, 48 Road-750 Black, 52 blue Black Black 511,55 539, 99 539, 99 Exercise 4: Use the same query, but this time you just want to see the rows that are NULL for the Color column. Your result set should look something like the following. ProductID Name Color ListPzice Adjustable Race Headset Ba1l Bearings Blade NULL NULL NULL 0, 00 0,00 0, 00 316 Exercise 5 Write a query that retrieves unique colors from the table Product Exercise6 Write a query that retrieves rows where colors that are black or blue from the table Product Show transcribed image text
Expert Answer
Answer to Exercise 1 Create Following Product Table Productid Name Color Listprice Adjustable Race H Q36689778 . . .
OR