w3resource

SQL Exercises: Find the number of products over or equal to Rs 350

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

Code Explanation:

The said SQL query is counting the number of rows in the 'item_mast' table where the "pro_price" column is greater than or equal to 350. The result of the count will be stored in a column called "Number of Products".

Practice Online


Query Visualization:

Duration:

Query visualization of Find the number of products with a price more than or equal to Rs.350 - Duration

Rows:

Query visualization of Find the number of products with a price more than or equal to Rs.350 - Rows

Cost:

Query visualization of Find the number of products with a price more than or equal to Rs.350 - Cost

Practice Online


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

Previous SQL Exercise: Calculate the average price of all the products.
Next SQL Exercise: Compute the average price for unique companies.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.

SQL: Tips of the Day

What is the best way to paginate results in SQL Server?

SELECT  *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
          FROM      Orders
          WHERE     OrderDate >= '1980-01-01'
        ) AS RowConstrainedResult
WHERE   RowNum >= 1
    AND RowNum < 20
ORDER BY RowNum

Database: SQL Server

Ref: https://bit.ly/3MGrNlk

 





We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook