Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL Exercises: Display the average price of items of each company, showing the name of the company

SQL JOINS: Exercise-23 with Solution

From the following tables write a SQL query to calculate the average price of items of each company. Return average value and company name.

Sample table: company_mast

Sample table: item_mast

Sample Solution:

SELECT AVG(pro_price), company_mast.com_name
   FROM item_mast INNER 
     JOIN company_mast
        ON item_mast.pro_com= company_mast.com_id
           GROUP BY company_mast.com_name;

Output of the Query:

avg			com_name
5000.0000000000000000	Samsung
650.0000000000000000	iBall
1475.0000000000000000	Epsion
500.0000000000000000	Frontech
250.0000000000000000	Zebronics
3200.0000000000000000	Asus

Relational Algebra Expression:

Relational Algebra Expression: Display the average price of items of each company, showing the name of the company.

Relational Algebra Tree:

Relational Algebra Tree: Display the average price of items of each company, showing the name of the company.

Practice Online


Query Visualization:

Duration:

Query visualization of Display the average price of items of each company, showing the name of the company - Duration

Rows:

Query visualization of Display the average price of items of each company, showing the name of the company - Rows

Cost:

Query visualization of Display the average price of items of each company, showing the name of the company - Cost

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL query to display the item name, price, and company name of all the products.
Next: 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.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3