SQL: Calculate the average price of all products of the manufacturer whose code is 16

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

SQL Basic Select Statement: Exercise-26 with Solution.

From the following table, write a SQL query to calculate the average price for a manufacturer code of 16. Return avg.

Sample table: item_mast

Sample Solution:

SELECT AVG(pro_price) FROM item_mast 
  WHERE pro_com=16;

Output of the Query:

avg
500.0000000000000000

Relational Algebra Expression:

Relational Algebra Tree:

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 select a range of products whose price is in the range Rs.200 to Rs.600. Begin and end values are included. Return pro_id, pro_name, pro_price, and pro_com.
Next: From the following table, write a SQL query to display the pro_name as 'Item Name' and pro_priceas 'Price in Rs.'

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