Chapter 13 Exercise 13

13. List all items in the Dog category with a list price above $20 and a QOH greater than 50. What indexes are needed?

The Merchandise(Category) index is the only one needed, but you need ALLOW FILTERING;
 
SELECT *
FROM Merchandise
WHERE Category='Dog'
AND ListPrice>20
AND QOH>50
ALLOW FILTERING;
 
(2 rows)
50-pound dog food and a leash