SQL Exercises: Calculate the average price of all the items

Last update on June 10 2022 09:28:01 (UTC/GMT +8 hours)

SQL Aggregate Functions: Exercise-21 with Solution

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

Sample table: item_mast

Sample Solution:

SELECT AVG(pro_price) AS "Average Price" 
   FROM item_mast;

Output of the Query:

Average Price
1435.0000000000000000

Duration:

Rows:

Cost:

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

Previous: From the following table, write a SQL query to count number of orders by the combination of each order date and salesperson. Return order date, salesperson id.
Next: From the following table, write a SQL query to count number of products where product price is higher than or equal to 350. Return number of products.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

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