Refer the given table and answer the question that follow: TABLE PRODUCT Pro_ID P1220 P1222 P1223...

Transcribed Image Text:

Refer the given table and answer the question that follow: TABLE PRODUCT Pro_ID P1220 P1222 P1223 P1224 Pro_Name BUTTER MILK MUFFINS CAKE Category DAIRY DAIRY BREAD BREAD Price 50.555 20.500 35.750 25.255 Sup_ID S1024 $1024 S2012 S2055 a. Write an SQL Query to display Product ID first 3 letters from the Product Name for the products with category DIARY and BREAD. (2.5 Marks) b. Write an SQL Query to calculate and display PRODUCT NAME PRICE after multiplying the price by 2 with an alias name NEWPRICE for those products where the name starts with letter M and Price more than 30. (2.5 Marks) c. Write an SQL Query to display unique Categories, round the price to 2 decimal places and display it in the ascending order of Price. (2.5 Marks) d. Write an SQL query to display Category in small letters, highest price for each category of products. (2.5 Marks) Refer the given table and answer the question that follow: TABLE PRODUCT Pro_ID P1220 P1222 P1223 P1224 Pro_Name BUTTER MILK MUFFINS CAKE Category DAIRY DAIRY BREAD BREAD Price 50.555 20.500 35.750 25.255 Sup_ID S1024 $1024 S2012 S2055 a. Write an SQL Query to display Product ID first 3 letters from the Product Name for the products with category DIARY and BREAD. (2.5 Marks) b. Write an SQL Query to calculate and display PRODUCT NAME PRICE after multiplying the price by 2 with an alias name NEWPRICE for those products where the name starts with letter M and Price more than 30. (2.5 Marks) c. Write an SQL Query to display unique Categories, round the price to 2 decimal places and display it in the ascending order of Price. (2.5 Marks) d. Write an SQL query to display Category in small letters, highest price for each category of products. (2.5 Marks)

Answer rating: 100% (QA)

a SQL Query to display Product ID first 3 letters from the Product Name for the products with catego... View the full answer