Find the room number of the rooms which can sit 50 to 100 students and their buildings.
return rooms ;return #1 that  sit at least 50 students ;return #1 that  sit at most 100 students ;return #1 in both #2 and #3 ;return room number of  #4 ;return buildings of  #4 ;return #5 ,   #6
['select', 'filter', 'filter', 'intersection', 'aggregate', 'project', 'union']