How many gas stations opened after 2000?
select count ( * ) from gas_station where open_year > 2000
What's the name of the manager that opened the most gas stations after 2000?
select manager_name from gas_station where open_year > 2000 group by manager_name order by count ( * ) desc limit 1
What are the locations of those?
select location from gas_station where manager_name = ( select manager_name from gas_station where open_year > 2000 group by manager_name order by count ( * ) desc limit 1 )
What are the vice manager names of those locations?
select location, vice_manager_name from gas_station where manager_name = ( select manager_name from gas_station where open_year > 2000 group by manager_name order by count ( * ) desc limit 1 )
What years did those open?
select location, open_year from gas_station where manager_name = ( select manager_name from gas_station where open_year > 2000 group by manager_name order by count ( * ) desc limit 1 )