Question

a) Create the following table Food_Items.

Column name Data type Size Constraint

ItemNo Numeric 3 Primary key

Iname Character 15

Price Numeric 10,2

Quantity_per_plate Numeric 3

b) Consider the following table Food_Items and write the queries (i) and (ii).



ItemNo IName Price Quantity_per_item

1 Dosa Sambhar 250 10

2 Pav Bhaji 2140 30

3 Chole Bhature 150 25

4 Paani Puri 105 15

5 Chaat 50 10

i. Write a command to insert a new record with the following values

(6 , ‘Chowmein’ , 160 , 6 )

ii. Write a query to display all the records of table whose prizes 125 or more.

OR

Write a query to display all the records in the table in descending order of

quantity_per_plate.​

Answer 1

Answer:

please mark me as brain list