Show the names of phones and the districts of markets they are on, in ascending order of the ranking of the market.
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
Which carriers are active in Alberta?
select t3.carrier 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.district = "Alberta"
Where else is TMobile active?
select 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 where t3.carrier = "TMobile" and t2.district ! = "Alberta"
Which phones does TMobile support?
select name from phone where carrier = "TMobile"