. The Head of Sales at ZoomZoom has asked for your help. She is particularly interested in scooter sales at dealerships. Connect to the sqlda database, then complete the following: a. To begin, you would like to get a list of the dealerships by state and you would like to know how many dealerships are in each state. Run an SQL query using a window function that returns individual rows for state and dealership ID plus a new column for the total number of dealerships in each state. Order the results by dealership ID. Create a table of the results that includes columns for the state, dealership ID and total number of dealerships in each state. Exclude states that do not have a dealership. b. Run an SQL query to determine the total number of scooters sold at each dealership in 2018. Create a table with the results that includes columns for the state, dealership ID and the total number of scooters sold at each dealership.