1. Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on Sundays of July, 2015--grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description.

could anyone please create the query for the above instruction?

Encounter CreditRating y CreditID Credit Description MinFICO MaxFICO Comments Customer * Customer CFirstName CLastName CPhone Annuallncome CreditID Y EnciD SalesID CustomerID EncDate Purchase Sales Person * SalesID SFirstName SlastName SHire Date Salary Encounter CreditRating y CreditID Credit Description MinFICO MaxFICO Comments Customer * Customer CFirstName CLastName CPhone Annuallncome CreditID Y EnciD SalesID CustomerID EncDate Purchase Sales Person * SalesID SFirstName SlastName SHire Date Salary