Database: phone_market
Question: Show the names of phones and the districts of markets they are on, in ascending order of the ranking of the market.
SQL:
SELECT T3.Name ,  T2.District 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 ORDER BY T2.Ranking