question: List all of the ids for left-footed players with a height between 180cm and 190cm.
#1 return players 
#2 return #1 that  are  left-footed 
#3 return heights of  #2 
#4 return #1 where  #3 is at least 180cm 
#5 return #1 where  #3 is at most 190cm 
#6 return #1 of  both #4 and #5