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?

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter9: Joining Data From Multiple Tables
Section: Chapter Questions
Problem 11MC
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
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS