Which player's results were T6 in the PGA Ch., T4 in the Masters and T8 at the U.S. Open?
CREATE TABLE table_1506950_9 (player VARCHAR, us_open VARCHAR, pga_ch VARCHAR, masters VARCHAR)
SELECT player FROM table_1506950_9 WHERE pga_ch = "T6" AND masters = "T4" AND us_open = "T8"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1506950_9 (player VARCHAR, us_open VARCHAR, pga_ch VARCHAR, masters VARCHAR) Question: Which player's results were T6 in the PGA Ch., T4 in the Masters and T8 at the U.S. Open? [/INST] SELECT player FROM table_1506950_9 WHERE pga_ch = "T6" AND masters = "T4" AND us_open = "T8" </s>