SQL Exercises: Find the number of products with a price greater than or equal to Rs.350

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

SQL Aggregate Functions: Exercise-22 with Solution

From the following table, write a SQL query to count the number of products whose price are higher than or equal to 350. Return number of products

Sample table: item_mast

Sample Solution:

SELECT COUNT(*) AS "Number of Products" 
  FROM item_mast 
    WHERE pro_price >= 350;

Output of the Query:

Number of Products
8

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 calculate the average product price. Return average product price.
Next: From the following table, write a SQL query to compute the average price for unique companies. Return average price and company id.

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