﻿ SQL: Display the name and price of all the items with a price is equal or more than Rs.250 in ascending order - w3resource

# SQL: Display the name and price of all the items with a price is equal or more than Rs.250 in ascending order

## SQL Basic Select Statement: Exercise-28 with Solution.

From the following table, write a SQL query to find the items whose prices are higher than or equal to \$250. Order the result by product price in descending, then product name in ascending. Return pro_name and pro_price.

Sample table: item_mast

Sample Solution:

``````SELECT pro_name, pro_price
FROM item_mast
WHERE pro_price >= 250
ORDER BY pro_price DESC, pro_name;
``````

Output of the Query:

```pro_name	   pro_price
Monitor	        5000.00
Mother Board	3200.00
Printer	        2600.00
DVD drive	     900.00
CD drive	     800.00
Speaker	         550.00
Key Board	     450.00
Refill cartridge 350.00
Mouse	         250.00
ZIP drive	     250.00
```

Relational Algebra Expression:

Relational Algebra Tree:

## Query Visualization:

Duration:

Rows:

Cost:

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

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿