SQL: Calculate the average price of all products of the manufacturer which code is 16
SQL Basic Select Statement : Exercise-26 with Solution.
Write a SQL query to calculate the average price of all products of the manufacturer which code is 16.
Sample table : item_mast
Sample Solution :
SELECT AVG(pro_price) FROM item_mast WHERE pro_com=16;
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?