For which of these tasks would you need to use a WHERE clause? Check all that apply.
- For a table of pets, including their owners and ages, finding the range of values in their ages
- For a table that includes which of many offices each employee works, finding all the employees in the Chicago office
- For a table of inventory items, including quantity and price, finding all inventory items priced under $5
- For a table of web logs, which show the IP addresses of every visit, removing rows with duplicate IP addresses