CREATE TABLE table_24535095_2 (team VARCHAR2, listed_owner_s_ VARCHAR2)

Name the team for susan bates
SELECT team FROM table_24535095_2 WHERE listed_owner_s_ = "Susan Bates"
SELECT "team" FROM "table_24535095_2" WHERE "Susan Bates" = "listed_owner_s_"