Find the name of players whose card is yes in the descending order of training hours.
CREATE TABLE Player (pName VARCHAR, yCard VARCHAR, HS VARCHAR)
SELECT pName FROM Player WHERE yCard = 'yes' ORDER BY HS DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Player (pName VARCHAR, yCard VARCHAR, HS VARCHAR) Question: Find the name of players whose card is yes in the descending order of training hours. [/INST] SELECT pName FROM Player WHERE yCard = 'yes' ORDER BY HS DESC </s>