CREATE TABLE phone_market (market_id NUMBER, phone_id CLOB, num_of_stock NUMBER)
CREATE TABLE phone (name CLOB, phone_id NUMBER, memory_in_g NUMBER, carrier CLOB, price NUMBER)
CREATE TABLE market (market_id NUMBER, district CLOB, num_of_employees NUMBER, num_of_shops NUMBER, ranking NUMBER)

Show the names of phones that are on market with number of shops greater than 50.
SELECT T3.name FROM phone_market AS T1 JOIN market AS T2 ON T1.market_id = T2.market_id JOIN phone AS T3 ON T1.phone_id = T3.phone_id WHERE T2.num_of_shops > 50
SELECT "T3"."name" FROM "phone_market" "T1" JOIN "market" "T2" ON "T1"."market_id" = "T2"."market_id" AND "T2"."num_of_shops" > 50 JOIN "phone" "T3" ON "T1"."phone_id" = "T3"."phone_id"