CREATE TABLE table_name_47 (cart VARCHAR, shield_animal VARCHAR)

What cart has a serpent shield animal?
SELECT cart FROM table_name_47 WHERE shield_animal = "serpent"
SELECT "cart" FROM "table_name_47" WHERE "serpent" = "shield_animal"