Question

Write a query to display all details of pets of species bird, snake or hamster from table pet.​

Answer 1

select color, name from pet group by color, name, species having species in ('snake', 'hamster', 'bird')