CREATE TABLE table_1506950_9 (player VARCHAR2, us_open VARCHAR2, pga_ch VARCHAR2, masters VARCHAR2)

Which player's results were T6 in the PGA Ch., T4 in the Masters and T8 at the U.S. Open?
SELECT player FROM table_1506950_9 WHERE pga_ch = "T6" AND masters = "T4" AND us_open = "T8"
SELECT "player" FROM "table_1506950_9" WHERE "T4" = "masters" AND "T6" = "pga_ch" AND "T8" = "us_open"