What are the names of the phones?
select name from phone
Show me their memory as well.
select name, memory_in_g from phone
Their total stocks?
select t2.name, sum(t1.num_of_stock) from phone_market as t1 join phone as t2 on t1.phone_id = t2.phone_id group by t2.name