yes! That did it. Thank you Harishgg1. just a slight modification: i added a column to call out which animal instance was being counted:
SELECT
'dog' AS animal,
count(case when vet.pets like '%dog%' THEN 1 ELSE NULL END) AS count
FROM vet
Union all
SELECT etc....
Thank you for the suggestion! 