rangeslikes1.sql
SELECT title, price
FROM menu
WHERE price > 15.00
AND price <= 19.95
.sql
rangeslikes2.sql
SELECT title
FROM menu
WHERE title LIKE '%chicken%'
.sql
rangeslikes3.sql
SELECT title
FROM menu
WHERE title LIKE 'Chicken%'
.sql
- Explain the difference between < and <=.
- Explain or research how the % wildcards (used in conjunction with LIKE) work in these three examples:
- '%chicken'
- 'Chicken%'
- '%chicken%'
- Show all the fields for items that have the word "lettuce" somewhere in their description
- Show the title, category and price of foods that have calories GREATER THAN 1000