What is the memory of the cheapest phone?
select memory_in_g from phone order by price asc limit 1
Include the name as well please.
select name, memory_in_g from phone order by price asc limit 1
What about for the most expensive phone?
select name, memory_in_g from phone order by price desc limit 1
Which company carries this?
select carrier from phone order by price desc limit 1