find the location and Representative name of the gas stations owned by the companies with top 3 Asset amounts.
select t3.location, t3.representative_name from station_company as t1 join company as t2 on t1.company_id = t2.company_id join gas_station as t3 on t1.station_id = t3.station_id order by t2.assets_billion desc limit 3
What is the representative name of Newport Rd?
select representative_name from gas_station where location = "Newport Rd"
Find the location and Representative name of the gas stations owned by the companies with top 3 Asset amounts.
select t3.location, t3.representative_name from station_company as t1 join company as t2 on t1.company_id = t2.company_id join gas_station as t3 on t1.station_id = t3.station_id order by t2.assets_billion desc limit 3
Which gas station location is the oldest based on its open year.
select location from gas_station order by open_year limit 1