Question: Please solve in oracle sql Question 1: Create a table name ITEM with variables ItemName, ItemID, ItemPrice, ItemAvailable and Quantity Marks = 1] Question 2:
Please solve in oracle sql

![with variables ItemName, ItemID, ItemPrice, ItemAvailable and Quantity Marks = 1] Question](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f39e516feb8_80866f39e50dc081.jpg)
Question 1: Create a table name ITEM with variables ItemName, ItemID, ItemPrice, ItemAvailable and Quantity Marks = 1] Question 2: Insert the following data into the ITEM table. [ Marks = 1] ItemName ItemID ItemPrice ItemAvailable Quantity Dress 021 10000 Yes 38 Perfume 022 5000 Yes 79 Shoes 023 800 No 34 Purse 024 20000 Yes 65 Question 3: Delete the Item which have 800 price. [ Marks = 1] Question 4: Insert the following data into the ITEM table. Marks = 1 ] ItemName ItemID ItemPrice ItemAvailable Quantity Long-Dress 021 8000 Yes 20 Chanel-Perfume 022 7000 Yes 10 Marks = 1] = Question 5: Write the Query using which you can show the items which have ItemID = 022 Question 6: Create a table ITEM1 from table ITEM and insert the following data. [ Marks = 1 ] ItemName ItemID ItemPrice ItemAvailable Quantity Dress 021 7000 Yes 38 Perfume 022 9000 Yes 79 Shoes 023 1000 Yes 34 Wallet 024 2000 Yes 65 Question 7: Write a query to select data from table ITEMI where ItemPrice > 9000 [Marks = 1] = Question 8: Write a query to calculate the average of Price from table ITEM Marks = 1] Question 9: Write a Query which will show the distinct rows from table ITEM and ITEMI [ Marks = 1] Question 10: Write a Query which will show the common values from table ITEM and ITEMI (Marks = 1 ]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
