SQL Exercises: Compute the average price for unique companies

SQL Aggregate Functions: Exercise-23 with Solution

From the following table, write a SQL query to compute the average price for unique companies. Return average price and company id.

Sample table: item_mast

Sample Solution:

SELECT AVG(pro_price) AS "Average Price", 
       pro_com AS "Company ID"
    FROM item_mast
GROUP BY pro_com;

Output of the Query:

Average Price			Company ID
250.0000000000000000		14
650.0000000000000000		12
3200.0000000000000000		15
5000.0000000000000000		11
1475.0000000000000000		13
500.0000000000000000		16

Code Explanation:

The said SQL query that returns the average price of items grouped by company. The query performs the following operations:
Selects the average price of items from the 'item_mast' table using the AVG function and assigns the result to the alias "Average Price".
Selects the company ID of each item from the 'item_mast' table and assigns it to the alias "Company ID".
Groups the results by the "pro_com" column, which represents the company ID of each item.
The final result is a table with two columns, "Average Price" and "Company ID", showing the average price of items for each company.

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

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

Previous SQL Exercise: Find the number of products over or equal to Rs 350.
Next SQL Exercise: Calculate the total allotment for all departments.