/* Extract the boolean values for 'isCat' from the 'user' table */ SELECT sum(CASE WHEN "isCat" = True THEN 1 ELSE 0 END) AS "Is a cat", sum(CASE WHEN "isCat" = False THEN 1 ELSE 0 END) AS "Is not a cat" FROM public.user