What is the average price of phones?
select avg(price) from phone
What about their names?
select name from phone
Of those, only tell me the ones that are either "Sprint" or "TMobile" carriers.
select name from phone where carrier = "Sprint" or carrier = "TMobile"