Your job is to create the $10$ queries listed below and answer questions about each query to verify whether you created it correctly. Notice that each quix question $($found after the entire list of queries$)$ refers to a specific query from the list. Be sure to refer to the appropriate query when answering each quix question. Although your grade comes from answering the quiz questions correctly, you must also submit the SQL you created to answer each question within the quiz questions below. $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 "Hansenor "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. $($Hints 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 FirstName, LastName, 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 "Falc. "Poor, "Very Poot." 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 total 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 Sth$,12$th$,19$th$,$ and $26$th$.$ Your answer should have two columns $($Credit Description and encounter count$)$ and should be sorted alphabetically by credit description A $\%$ Conditional Formatting Format as Tablo v Paste Font Alignment Number Cells Cell Styles Editing ES x vfx $56000$ C D E F G $.1$ OWN Salesid SFirstName SlastName SHireDate Salary $1$ Harry Potter $2/13/89$ $$140,000\mathrm{.}002$ Hermione Granger $5/2/89$ $$82,000\mathrm{.}003$ Ron Weasley $5/2/89$ $$93,000\mathrm{.}004$ Dudley Dursley $4/27/96$ $$56,000\mathrm{.}005$ Katie Bell $5/15/96$ $$67,000\mathrm{.}006$ Ginny Weasley $6/1/01$ $$75,000\mathrm{.}007$ Neville Longbottoi $11/9/04$ $$71,000\mathrm{.}008$ Colin Creevey $4/26/06562,000\mathrm{.}00891012$ Enter the SQL code that you wrote to answer Query $1.$ Format Font Size $-$ BIU $112($Query $1)$ Which employee has been employed with GGA for the longest period of time? Harry Potter Hermione Granger Ron Weasley Dudley Dursley Katie Bell Ginny Weasley Colin Creevey Neville Longbottom None of the Above $3($Query $1)$ What is the salary of the second most recently hired employee? $($Answer should be inputted to the nearest whole number$-$O decimal places. Do not include any dollar signs or commas!$)($Query $1)$ On what date was the most recently hired employee hired on at GGA? $($Use the MM$/$DD$/$YYYY format$)$ Enter the SQL code that you wrote to answer Query $2.$ Format Font Stre $-$ A$.$ AQ$8$ X BI VSX$,*.*4($Query $2)$ How many records are in the result? $($Answer should be inputted to the nearest whole number$-$O decimal places.$)($Query $2)$ True or fulse: Richard Martin is one of the customers in the results. True False $($Query $2)$ True or false: Leticia McCloud is one of the customers in the results. True False Enter the SQL code that you wrote to answer Query $3.$ Format Font Size A$.$ AQS BI U $5$ x x $1.185910($Query $3)$ How many records were displayed in your results? $($Select the range in which your answer falls.$)1$ to $23$ to $56$ to $1213$ to $2122$ to $2829$ to $3435$ to $3940$ to $44$ None of the Above $21($Query $3)$ True or false: Carmen Page and Seth Romney were customers that bought from Kate and fit the question query criteria True False $12($Query $4)$ Which customer$($s$)$ had a credit description of poor? Diego Castro Sarah Scarborough Martin March Isabella Munoz Robin Webb Helen Fisher None of the above $13$ Enter the SQL code that you wrote to answer Query Fom Font A Bas BIUS X$,$ X T$.14($Query $4)$ How many customers had credit descriptions of "Extremely poor?" $($Answer should be inputted to the nearest whole number$-$O decimal places.$)15($Query $4)$ True or false: Andrew Buchanon is one of the customers in the results. True False Query $4)$ Which of the following customers has a first name that starts with the letter $"$M$"$ and appears in your results for query $47($Select all that apply Mark Mitchell Martin $17$ Enter the SQL code that you wrote to answer Query $5$ Formal Font A$.$ AQ BI U $5$ X X $1.18($Query $5)$ True or false: Colin worked with more than one customer who had the last name "Hanson" or "Hansen" $(.$e$.,$ more than one Hanson or more th True False $19($Query $5)$ Enter the phone number of the customer with the last name of "Hanson." $($Enter the phone number with no hyphens, spaces, periods, or parentheses; your answer should look something like $"1234567890\mathrm{.}920$ Enter the SQL code that you wrote to answer Query Format Font Size A$.$ AQ BIUS X$,$ X T$.$ I $21($Query $6)$ How many rows of data did your query return? $41-8000-2081-140$ B $21-40>141($Query $6)$ Input the number of encounters that did not result in a purchase. $($Note: don't confuse the number of encounters with the mamber of records retum $($Answer should be input to the nearest whole number $--$O decimal places. Do not use any dollar signs ar commast$)25$ Enter the SQL code that you vote to answer Query $7.$ Format Font Sie A$.-$ Q US X$,$ X $24($Query$)$ Which two salespersons had the fewest encounters based on this query? Dudley Dursley and Hermione Granger Ginny Weasley and Colin Creevey Katie Bell and Colin Creevey Colin Creevey and Hermione Granger $25($Query $7)$ What is the name of the third salesperson in this list resulting from Query $77$ Dudley Dursley Neville Longbottom Ginny Weasley Colin Creevey $26$ Enter the SQL code that you wote to answer Query $8.$ Format Font Sie BIUS X$,$ X $27($Query $8)$ Input the average annual income displayed in your query $($Your answer should be entered with two decimal places. Do not use any dollar signs or commast$)28$ Enter the SQL code that you wrote to answer Query $9.$ Format $-$ Font Siye A$.$ A to BIUS X$,$ X T$.9929($ery How many customers have credit description of a we should be inputted to the nearest whole number$-$decimal places$)30($Query$)$ True or false: The query result indicates that only two customers have credit description of very poor and only three customers have credit descriptions of poor. True Enter the SQL code that you wrote to nie wery $10-$ Font AQ BIUS $132($Query $10)$ Based on the data, what type of customers are most likely to show up on a Sunday in July? Those who donk get their credit pulled or checked at the dealership Those with good credit ratings Those with very good credit ratings Those with fair credit ratings Those with very poor credit ratings $($Query $10)$ True or false: There are people that came in on Sundays in July without getting their credit checked or pulled at the dealership, True False Submit Assessment $22($Query $6)$ Input the number of encounters that did not result in a purchase. $($Note: don't confuse the number of encounters with the number of records returned$)($Answer should be input to the nearest whole number $-$ decimal places. Do not use any dollar signs or commas$)18($Query S$)$ True or false: Colin orked with more than one customer who had the last name "Hanson" or "Hansene, more than one Hansen or more than ane Hansen True False $10($Query $3)$ How many records were displayed in your results? $($Select the range in which your answer falls.$)1$ to $23$ to $56$ to $1213$ to $21$ E $22$ to $2829$ to $3435$ to $39$ m $40$ to $44$ None of the above $21($Query $3)$ True or false: Carmen Page and Seth Romney were customers that bought from Kate and fit the question query criteria True False