1. Create an SQL query for the following:
2. Customers with low annual income or poor credit ratings often have trouble qualifying for credit. A new, local credit agency may be better able to serve this market segment than the current options can. The manager would like to talk to a few salespeople who have had the most encounters with these customers. Create a list that shows each salesperson (first and last name) and the number of encounters each has had with customers that have an annual income of $25,000 or less or have a credit description that is Very Poor or Extremely Poor. Order the results alphabetically by the salespersons last name. Your query should have three columns: sFirstName, sLastName, encounter_count.

Customer Encounter CreditRating 7 CreditID CreditDescription MinFICO MaxFICO Comments * Customer CFirstName CLastName CPhone AnnualIncome CreditID * EncID SalesID Customer EncDate Purchase Sales Person Y SalesID SFirstName SlastName SHireDate Salary