Which players have won an award?
select t1.name_first, t1.name_last from player as t1 join player_award as t2 on t1.player_id = t2.player_id group by t2.player_id
Who won an award in 1960?
select t1.name_first, t1.name_last from player as t1 join player_award as t2 on t1.player_id = t2.player_id where t2.year = 1960 group by t2.player_id
How about in 1961?
select t1.name_first, t1.name_last from player as t1 join player_award as t2 on t1.player_id = t2.player_id where t2.year = 1961 group by t2.player_id
Among the players, who won awards both in 1960 and in 1961?
select t1.name_first, t1.name_last from player as t1 join player_award as t2 on t1.player_id = t2.player_id where t2.year = 1960 intersect select t1.name_first, t1.name_last from player as t1 join player_award as t2 where t2.year = 1961