Question: SQL Questions: Use the data model below to answer the following SQL questions. (worth 68 points) PK ORDER_T PK Order ID Order_Date Customer_ID CUSTOMERT Customer

SQL Questions: Use the data model below to answer

SQL Questions: Use the data model below to answer the following SQL questions. (worth 68 points) PK ORDER_T PK Order ID Order_Date Customer_ID CUSTOMERT Customer ID Customer_FName Customer_LName Customer_Address Customer_City Customer_State Customer_Zip ed | PKD PK Product T Product ID Product_Name Product_Finish Standard_Price Product_Line_ID ORDER LINE T Order ID Product ID Ordered Quantity a) Write the SQL statement that will retrieve all the record for customers whose Customer FName. contains the phrase 'Chris'. The data type of Customer EName is string. (worth 6 points) b) Write the SQL statement that will display Product ID Product Nape, and Standard Price for products whose price between 50 and 200. (worth 6 points) c) Write the SQL statement that will display Product ID Product Name, and Standard Price for each product that does not have a price of 50, 70, or 100. (worth 6 points) SQL Questions: Use the data model below to answer the following SQL questions. (worth 68 points) PK ORDER_T PK Order ID Order_Date Customer_ID CUSTOMERT Customer ID Customer_FName Customer_LName Customer_Address Customer_City Customer_State Customer_Zip ed | PKD PK Product T Product ID Product_Name Product_Finish Standard_Price Product_Line_ID ORDER LINE T Order ID Product ID Ordered Quantity a) Write the SQL statement that will retrieve all the record for customers whose Customer FName. contains the phrase 'Chris'. The data type of Customer EName is string. (worth 6 points) b) Write the SQL statement that will display Product ID Product Nape, and Standard Price for products whose price between 50 and 200. (worth 6 points) c) Write the SQL statement that will display Product ID Product Name, and Standard Price for each product that does not have a price of 50, 70, or 100. (worth 6 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!