2. In a recent survey, Netflix has found out that customers from certain areas are potentially more likely to rate movies that have received an Oscar. To better market to their customers, Netflix has asked you to create a query that will return each state (ex. "NY"), the total number of movie ratings from customers of that state, and then a count of how many of those ratings were of a movie which won an award