11. Open the GroupbyStateQuery in SQL View. Modify the query by completing the following task: a. Add the state field to the SELECT statement. The State field should appear before the COUNT(CustomerID) function. b. Group the records by the state field. c. Sort the records by the state field in ascending order. Run the query and confirm that the results match those shown in Figure 11. Save and close the GroupbystateQuery