SQL Exercises: Find all products between Rs.200 and Rs.600
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.
Sample table: item_mast
PRO_ID PRO_NAME PRO_PRICE PRO_COM
------- ------------------------- -------------- ----------
101 Mother Board 3200.00 15
102 Key Board 450.00 16
103 ZIP drive 250.00 14
104 Speaker 550.00 16
105 Monitor 5000.00 11
106 DVD drive 900.00 12
107 CD drive 800.00 12
108 Printer 2600.00 13
109 Refill cartridge 350.00 13
110 Mouse 250.00 12
Sample Solution :
-- This query selects all columns from the 'item_mast' table.
SELECT *
-- Specifies the table from which to retrieve the data (in this case, 'item_mast').
FROM item_mast
-- Filters the rows to only include those where the 'pro_price' column is between 200 and 600 (inclusive).
WHERE pro_price BETWEEN 200 AND 600;
Output of the Query:
pro_id pro_name pro_price pro_com 102 Key Board 450.00 16 103 ZIP drive 250.00 14 104 Speaker 550.00 16 109 Refill cartridge 350.00 13 110 Mouse 250.00 12
Code Explanation:
The said SQL query that retrieves all columns from the table 'item_mast' where the column "pro_price" has a value between 200 and 600. The "SELECT *" statement returns all columns, and the "WHERE pro_price BETWEEN 200 AND 600" filters the results to only show rows where the value of the "pro_price" column falls within that range.
Relational Algebra Expression:
Relational Algebra Tree:
Practice Online
For more Practice: Solve these Related Problems:
- Write a SQL query to find products priced between Rs.500 and Rs.1000.
- Write a SQL query to retrieve items costing between Rs.100 and Rs.300.
- Write a SQL query to list products priced between Rs.1000 and Rs.5000.
- Write a SQL query to display items with prices between Rs.50 and Rs.200.
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous SQL Exercise: Economics, Chemistry listed at end of 1970 as winners.
Next SQL Exercise: Average price of all products of the given manufacturer.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.