Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 5 The food_orders table contains the following information: Not yet answered Food_Orders Table Marked out of 1.00 ITEM_ID ITEM_NAME UNIT_PRICE UNIT_ORDERED DISCOUNT 1 Chicken
Question 5 The food_orders table contains the following information: Not yet answered Food_Orders Table Marked out of 1.00 ITEM_ID ITEM_NAME UNIT_PRICE UNIT_ORDERED DISCOUNT 1 Chicken Burger 1 2 Flag question TO2 Pasta 3.5 3 2 TO3 Potato Wedgt 2 4 .8 T04 Italian Pizza 2.6 2. 3 TOS Sweet Com Soup 1.5 You need to create a report to display the Items names and the unit price of all food items. Which SQL statements should you use to display the price in the format: "$3.50" for Item number TO2? O a SELECT item_name, TO_NUM (unit_price, '$9.90') AS price FROM food_orders WHERE item_id='T02' O b. SELCT item_name, TO_CHAR(unit_price, '$99.0') AS price FROM food_orders WHERE item_id='102' O C. SELECT item_name, TO_CHAR (unit_price, '$9.90') AS price FORM food_orders WHERE item_id='102' O d. SELCT item_name, TO_NUM (unit_price, '$99.0') AS price FROM food_orders WHERE item_id='T02
Step 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