Write a query to display all female patients living in California along with the total number of diagnosis records that...

Write a query to display all female patients living in California along with the total number of diagnosis records that have been entered for the patient. Display patient Id, patient gender, patient state, year of birth, and the total number of diagnosis records. Give the summary column (total number of diagnosis records) a meaningful name. Include all patients whether or not they have a diagnosis