Legs:

SELECT ID, Name, Species, Legs, Danger, Birth
FROM Pets
WHERE Legs = 0
ORDER BY Name ASC;

Birth Old < 2010:

SELECT ID, Name, Species, Legs, Danger, Birth
FROM Pets
WHERE Birth < '2010-01-01'
ORDER BY Birth ASC;

Danger > 7:

SELECT ID, Name, Species, Legs, Danger, Birth
FROM Pets
WHERE Danger >= 7
ORDER BY Danger DESC;

Cuddle:

SELECT ID, Name, Species, Legs, Danger, Birth
FROM Pets
WHERE Species IN ('Cat', 'Bunny', 'Monkey')
ORDER BY Species ASC, Name ASC;

Young, Safe, Walkable:

SELECT ID, Name, Species, Legs, Danger, Birth
FROM Pets
WHERE Danger <= 3
  AND Legs >= 4
  AND Birth > '2005-01-01'
ORDER BY Danger ASC, Birth DESC;