Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL Subquery Exercises: Display the average price of the products which is more than or equal to 350 along with their names

SQL SUBQUERY: Exercise-32 with Solution

32. From the following tables write a SQL query to calculate the average price of each manufacturer's product of 350 or more. Return Average Price and Company.

Sample table: company_mast


Sample table: item_mast


Sample Solution:

SELECT AVG(pro_price) AS "Average Price", 
   company_mast.com_name AS "Company"
      FROM item_mast, company_mast
         WHERE item_mast.pro_com= company_mast.com_id
           GROUP BY company_mast.com_name
   HAVING AVG(pro_price) >= 350;

Output of the Query:

Average Price		Company
5000.0000000000000000	Samsung
650.0000000000000000	iBall
1475.0000000000000000	Epsion
500.0000000000000000	Frontech
3200.0000000000000000	Asus

Pictorial Presentation:

SQL Subqueries Inventory Exercises: Display the average price of the products which is more than or equal to 350 along with their names.

Practice Online


Sample Database:

Model Database

Query Visualization:

Duration:

Query visualization of Display the average price of the products which is more than or equal to 350 along with their names - Duration

Rows:

Query visualization of Display the average price of the products which is more than or equal to 350 along with theri names - Rows

Cost:

Query visualization of Display the average price of the products which is more than or equal to 350 along with their names - Cost

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find the average price of each manufacturer's product along with their name. Return Average Price and Company.
Next: From the following tables, write a SQL query to find the most expensive product of each company. Return Product Name, Price and Company.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



SQL: Tips of the Day

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