In my table
select state,friend,count(*) as quan from friends group by state,friend order by friend
I get a long list with tha data I need. friend can appear more than once for a given state.
Arizona, John,12 (meaning in arizona I have 12 friendsa called john. And so forth.
I need a table that wiil have:
a comun called friend and one column for each state. And the value (Quan) the number