Tell me the birthday of the player named "Aaron Hunt".
select birthday from player where player_name = "Aaron Hunt"
What is his preferred foot?
select t2.preferred_foot from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t1.player_name = "Aaron Hunt"
List all of the ids for left-footed players with a height between 180cm and 190cm.
select player_api_id from player where height >= 180 and height <= 190 intersect select player_api_id from player_attributes where preferred_foot = "left"