Select all the products with a price between $60 and $120.
| SELECT name, price FROM products WHERE price >= 60
| WHERE price <= 120
| PROJECT name
3 rows 0 msec
| WHERE price <= 120
| PROJECT name
3 rows 0 msec
| name |
|---|
| Memory |
| CD drive |
| Toner cartridge |
If you have two conditions on the same table, use the WHERE statement to further refine.
You need to include the field price to be able to apply the condition.
Then you drop it using the PROJECT statement,.