What are the names of all the players?
select pname from player
Which of those received a card?
select pname from player where ycard = 'yes'
Set them in descending order of hours spent training.
select pname from player where ycard = 'yes' order by hs desc