Consider the table Inventory with columns quantity and type. What rows will this query return?
SELECT * FROM Inventory WHERE CASE WHEN type = 'Perishable' THEN quantity < 20 ELSE quantity >= 50 END;
ARows where perishable items have quantity 50 or more, and non-perishable items have quantity less than 20
BRows where all items have quantity less than 20
CRows where all items have quantity 50 or more
DRows where perishable items have quantity less than 20, and non-perishable items have quantity 50 or more
