SELECT ID, Color, Name, PetShop, Type
FROM Demo.Pet
WHERE color = 'yellow' and type = 'bird' and name = 'Edgar'
GO