15. SQL Optimization using 'Explain' and Indexing ( 10 points; 5 points each) a) Analyze the following SQL query on our store database: SELECT customer, COUNT(id) AS number_of_orders FROM Orders WHERE date BETWEEN '2022-01-01' AND '2022-12-31' GROUP BY customer HAVING number_of_orders > 5; The ANALYZE output for this query on the Orders table is as follows: Focus specifically on the 'possible_keys', 'key', 'rows', and 'r_rows' columns of the 'ANALYZE' output. Discuss how each of these elements indicates a performance issue or inefficiency in the query execution. b) Based on your analysis in Part (a), propose specific indexing strategies for the 'Orders' table to optimize the query's execution. Write out the SQL for your indexing strategy, and explain how your proposed changes will enhance performance, considering the detailed 'ANALYZE' output and the structure of the query