SQL Exercises: Calculate the average price of all the products

Last update on February 11 2025 08:02:07 (UTC/GMT +8 hours)

From the following table, write a SQL query to calculate the average product price. Return average product price.

Sample table: item_mast

 PRO_ID PRO_NAME                       PRO_PRICE    PRO_COM
------- ------------------------- -------------- ----------
    101 Mother Board                    3200.00         15
    102 Key Board                        450.00         16
    103 ZIP drive                        250.00         14
    104 Speaker                          550.00         16
    105 Monitor                         5000.00         11
    106 DVD drive                        900.00         12
    107 CD drive                         800.00         12
    108 Printer                         2600.00         13
    109 Refill cartridge                 350.00         13
    110 Mouse                            250.00         12

Sample Solution:

-- This query calculates the average 'pro_price' from the 'item_mast' table and assigns it the alias "Average Price".
SELECT AVG(pro_price) AS "Average Price"
-- Specifies the table from which to retrieve the data (in this case, 'item_mast').
FROM item_mast;

Output of the Query:

Average Price
1435.0000000000000000

Code Explanation:

The said SQL query calculates the average price of all items in the 'item_mast' table. The "AVG(pro_price)" function calculates the average value of the "pro_price" column, and the "AS 'Average Price'" clause gives the result column a label of "Average Price".

Practice Online

For more Practice: Solve these Related Problems:

• Write a SQL query to calculate the average product price for products with a price greater than 500.
• Write a SQL query to calculate the average product price for products with a price less than 1000.
• Write a SQL query to calculate the average product price for products with a price between 200 and 800.
• Write a SQL query to calculate the average product price for products with a price greater than 1000 and less than 3000.

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

Previous SQL Exercise: Count how many salesmen each day register orders.
Next SQL Exercise: Find the number of products over or equal to Rs 350.