Suppose you are working with a pet supply store’s database that contains an Items table with the following columns: Item#, ItemName, PetCategory, Price, and Vendor. Which SQL query would you write to retrieve a list of items in the cat pet category that cost $20 or less?

Question

Answer

SELECT Item#, ItemName FROM Items WHERE PetCategory = 'Cat' OR Price < 20.00

Answer

SELECT Item#, ItemName FROM Items WHERE PetCategory = 'Cat' AND Price < 20.00

Answer

SELECT Item#, ItemName FROM Items WHERE NOT (PetCategory = 'Dog' AND Price < 20.00)

Answer

WHERE PetCategory = 'Cat' AND Price < 20.00 SELECT Item#, ItemName FROM Items

Crowdly

Suppose you are working with a pet supply store’s database that contains an Item...

Want instant access to all verified answers on ubmoodle.ub.edu.bs?