Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Database Marketing The Ultimate Marketing Tool

Authors: Edward L. Nash

1st Edition

0070460639, 978-0070460638

More Books

Students also viewed these Databases questions

Question

Finding and scheduling appointments with new prospective clients.

Answered: 1 week ago