-- Database schema
| AREA_CODE_STATE : area_code [ INT ] primary_key , state [ TEXT ] | CONTESTANTS : contestant_number [ INT ] primary_key , contestant_name [ TEXT ] | VOTES : vote_id [ INT ] primary_key , phone_number [ INT ] , state [ TEXT ] VOTES.state = AREA_CODE_STATE.state , contestant_number [ INT ] VOTES.contestant_number = CONTESTANTS.contestant_number , created [ TEXT ] |
-- -- List the vote ids, phone numbers and states of all votes.

SELECT vote_id ,  phone_number ,  state FROM votes;