1
2
3
4
5
6
7
8
9
10
11
12
SELECT
    animal_id ,
    name ,
    CASE
        WHEN sex_upon_intake LIKE 'Neutered%' Then 'O'
        WHEN sex_upon_intake LIKE 'Spayed%' Then 'O'
        WHEN sex_upon_intake LIKE 'Intact%' THEN 'X'
    END
FROM
    animal_ins
ORDER BY 
    animal_id