Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning C# 2005 Databases

Authors: Karli Watson

1st Edition

0470044063, 978-0470044063

More Books

Students also viewed these Databases questions