Can you list all market ids and the names of the districts associated with them?
select market_id, district from market
Can you add to the table the phone ids from the table phone market that are associated with each market id?
select t1.market_id,t1.district,t2.phone_id from market as t1 join phone_market as t2 on t1.market_id = t2.market_id
Can you add to the table the name of the phones associated with each of the phone ids?
select t2.market_id, t2.district,t1.phone_id,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
Can you sort the table by phone id, but still retain all information within the table?
select t2.market_id, t2.district,t1.phone_id,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 order by t1.phone_id