CREATE TABLE table_name_7 (member VARCHAR2, state VARCHAR2)

Which memeber has nt as the state?
SELECT member FROM table_name_7 WHERE state = "nt"
SELECT "member" FROM "table_name_7" WHERE "nt" = "state"