Hello!  Can you tell me how many left footed players there are?
select count ( * ) from player_attributes where preferred_foot = "left"
Holy smokes that's a lot!  Okay, let's narrow that down.  How many left footed players have a height between 180cm and 190cm?
select count ( * ) from ( select player_api_id from player where height > = 180 and height < = 190 intersect select player_api_id from player_attributes where preferred_foot = "left" )
Thank you!  Can you please list player ids for all of the left-footed players with heights 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"
Great!  Can you tell me the name of the player who is the tallest left-footed player?
select player_name from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.preferred_foot = "left" order by height desc limit 1