Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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