CREATE TABLE gas_station (location VARCHAR, station_id VARCHAR)
CREATE TABLE station_company (company_id VARCHAR, station_id VARCHAR)
CREATE TABLE company (company_id VARCHAR, market_value INT)

Show all locations where a gas station for company with market value greater than 100 is located.
SELECT T3.location 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 WHERE T2.market_value > 100
SELECT "T3"."location" FROM "station_company" AS "T1" JOIN "company" AS "T2" ON "T1"."company_id" = "T2"."company_id" AND "T2"."market_value" > 100 JOIN "gas_station" AS "T3" ON "T1"."station_id" = "T3"."station_id"