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.

Enter the SQL code that you wrote to answer Query 7.

creditrating \# creditid (i) creditdescription (1) \# minfico \# maxfico (1) comments (1) customer \# customerid T cfirstname 1] clastname cphone (1) \# annualincome (1) \# creditid (1) encounter \# encid (1) \# salesid (1) \# customerid (1) enodate (i) - purchase salesperson \# salesid (1) sfirstname slastname shiredate \# salary (1)