Can you show me the total number of phones?
select count ( * ) from phone
how about the total number of different carriers?
select count ( distinct carrier ) from phone
Can you list the phones with carrier either Sprint or TMobile?
select phone_id from phone where carrier = 'Sprint' or carrier = 'TMobile'
Can you please include their names?
select phone_id, name from phone where carrier = 'Sprint' or carrier = 'TMobile'