CREATE TABLE table_name_44 (name VARCHAR2, position VARCHAR2, home_town VARCHAR2)

What is the name of the guard from Cary, NC?
SELECT name FROM table_name_44 WHERE position = "guard" AND home_town = "cary, nc"
SELECT "name" FROM "table_name_44" WHERE "cary, nc" = "home_town" AND "guard" = "position"