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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!