Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
6- From the following tables write a SQL query to calculate and find the average price of items of each company higher than or equal to Rs. 350. Return average value and company name?

6- From the following tables write a SQL query to calculate and find the average price of items of each company higher than or equal to Rs. 350. Return average value and company name?

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

using oracle

using oracle 6- From the following tables write a SQL query to calculate and find the average price of items of each company higher than or equal to Rs. 350. Return average value and company name? company_mast COM ID COM NAME 11 Samsung 12 iBall 13 Epsion: 14 Zebronics 15 Asus 16 Frontech item_mast PRO ID PRO_NAME 101 Mother Board 102 Key Board 103 ZIP drive 104 Speaker 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse emp_department DPT CODE DPT_NAME 57 IT 63 Finance 47 HR 27 RD QC 89 127323 Michale 526689 Carlos 843795 Enric 328717 Jhon 444527 Joseph 659831 Zanifer 847674 Kuleswar 748681 Henrey 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria PRO_PRICE aid 3200.00 Robbin Snares Dosio Snares Dosni Emily 450.00 250.00 550.00 5000.00 900.00 800.00 2600.00 Snappy Foster DPT ALLOTMENT 350.00 250.00 65000 15000 240000 55000 75000 EMP LNAME Sitaraman Gabriel Manuel Mardy Saul PRO COM UC q8 EMP DEPT 57 63 57 63 47 47 57 47 57 27 27 57
Transcribed Image Text:using oracle 6- From the following tables write a SQL query to calculate and find the average price of items of each company higher than or equal to Rs. 350. Return average value and company name? company_mast COM ID COM NAME 11 Samsung 12 iBall 13 Epsion: 14 Zebronics 15 Asus 16 Frontech item_mast PRO ID PRO_NAME 101 Mother Board 102 Key Board 103 ZIP drive 104 Speaker 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse emp_department DPT CODE DPT_NAME 57 IT 63 Finance 47 HR 27 RD QC 89 127323 Michale 526689 Carlos 843795 Enric 328717 Jhon 444527 Joseph 659831 Zanifer 847674 Kuleswar 748681 Henrey 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria PRO_PRICE aid 3200.00 Robbin Snares Dosio Snares Dosni Emily 450.00 250.00 550.00 5000.00 900.00 800.00 2600.00 Snappy Foster DPT ALLOTMENT 350.00 250.00 65000 15000 240000 55000 75000 EMP LNAME Sitaraman Gabriel Manuel Mardy Saul PRO COM UC q8 EMP DEPT 57 63 57 63 47 47 57 47 57 27 27 57
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS