We want to look at statistics of states where there is at least one person using a computer. Using a single query select from the additional_person_info view: For each state, give the following summary information (result should have seven columns and one row for each state). State name ,Number of people reported ,Number of people and how they connect to the internet (internet column)- Hint: review distinct values here, there will be a bit of transformation that you will need to do, look at case statements Number of people who own a personal computer Highest income (format as currency) Average income (format as currency) This is the challenging part: Of the people who own a personal computer, calculate the percentage of people who specifically use cellular to access the internet).
