CREATE TABLE table_name_34 (name VARCHAR2, team_sites VARCHAR2, public VARCHAR2, personal_sites VARCHAR2)

What is the name for the entry that has a public of Yes, a personal sites of No, and a team sites of No?
SELECT name FROM table_name_34 WHERE public = "yes" AND personal_sites = "no" AND team_sites = "no"
SELECT "name" FROM "table_name_34" WHERE "no" = "personal_sites" AND "no" = "team_sites" AND "public" = "yes"