Using Microsoft SQL Server Management Studio, answer the following questions and provide a screenshot for each.

1. Provide a count of the number of stores in each state
2. Show the top 30 customer zip codes in the country according to sales (not net sales).
3. Select one state and, using 2015 data, show annual net sales (purchases minus refunds) for each store in that state. Show each stores number, city, state, and zip, and show results in descending order of annual net sales.