I need awnsers for query 2 please.

1. Generate a list of salespeople and sort it in descending order by hire date. Show the first name, last name, hire date, and salary for each salesperson. 2. Generate a list of customers whose last name begins with the letter "M." Show the first and last names of these customers. Sort the list of customers in descending order by last name. 3. Generate a list of customers with annual incomes greater than $80,000 who purchased cars from salesperson "Katie," Show the first name, last name, and annual income of each of these customers. 4. Which customers purchased vehicles from salesperson "Dudley" despite having a "Poor," "Very Poor," or "Extremely Poor" credit rating? Show the first name, last name, and credit description for these customers. 5. Salesperson Colin recently had an encounter with a customer who he would like to contact again. Unfortunately, Colin can't remember if the customer's last name was "Hansen" or "Hanson." Construct a query to help Colin find the correct customer to follow up with. Show the customer's first name, last name, and phone number. 6. Construct a query to count how many encounters resulted in the customer declining to make a purchase, Use the COUNT function. (Hint: a customer can have many encounters) 7. 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 salesperson's last name. Your query should have three columns: sFirstName, sLastName, encounter_count. 8. Generate a query to find the average income of customers who purchased a car on their interaction. 9. Construct a query to show customers with an annual income greater than $100,000 who have a credit rating of "Fair," "Poor," "Very Poor," or "Extremely Poor." Show each customer's first name, last name, credit description, and annual income. 10. 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 the 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. You may use the MyEducator book, notes, class slides, and the internet to complete this assignment. (Answer should be inputted to the nearest whole number- 0 decimal places.) (Query 2) True or false: Richard Martin is one of the customers in the results. (Query 2) True or false: Leficia McCloud is one of the customers in the results. Paste the SQL code that you wrote to answer Query 3