SELECT title, price
WHERE price > 15.00
AND price <= 19.95
WHERE title LIKE '%chicken%'
WHERE title LIKE 'Chicken%'
- Explain the difference between < and <=.
- Explain or research how the % wildcards (used in conjunction with LIKE) work in these three examples:
- 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