Please help with Part IV Analytics mindset $-$OSU$-$P$-$Card case. $==========$ Part IV: Please explain$12$ Queries with a Screenshot supporting the answers. $===============$Please Label each solutions using the following convention:

qry$\_$T$4\_$Question#$,$ where # should be the question number. For example, the answer to a question

should be labeled qry$\_$T$4\_$Question$3.$ If multiple queries, then label the final query $($i$.$e$.,$ the querywith the solution$)$ as qry$\_$T$4\_$Question$3$Final, making sure to replace the number three in the example with the question number. Some queries will require multiple queries to get the final answer.

$1.$ Show all transactions sorted by amount $($smallest to largest$),$ with the most expensive transactions

listed first. Display the year, month, cardholder name, the amount of the transaction and the vendor.

$2.$ Show all transactions that occurred in the $2014$ calendar year sorted by month, and then, within each

month, list the most expensive transactions first and then alphabetize them by the name of the employee. Display the year, month, cardholder name, the amount of the transaction and the vendor. $3.$ Show all transactions that occurred in the $2014$ calendar year for more than $$3,000.$ Sort by month

and then within each month list the most expensive transactions first and then alphabetize by the name of the employee. Display the year, month, cardholder name, the amount of the transaction and

the vendor.

$4.$ Show all transactions that came from a vendor with Amazon somewhere in the name that occurred in

the $2014$ calendar year that are more than $$3,000.$ Display the vendor name, employee name,amount, year and month. Sort by amount so the smallest amount is listed first.

$5.$ What is the total number of P$-$card transactions in the database? Label the column TotalTrans.

$6.$ What is the total number of P$-$card transactions in the database with amounts more than or equal to $$5,000?$ Label the column TotalTransGT$5$k$.$

$7.$ What is the total dollar amount of transactions returned from January to March, inclusive, in $2014?$Label the column TotalReturns$2014$Q$1.$

$8.$ What is the total number of P$-$card transactions in the database for each year? Sort the data by year so the most recent date is listed first. Label the column with the counts as TotalTrans.

$9.$ List the names of all cardholders sorted based on who had the most transactions in the $2014$

calendar year. Display the name and number of transactions $($labeled as NumTrans$).$

$10.$ List the names of all people and sort based on who returned the greatest dollar amount of goods in

the $2014$ calendar year. Display the name, total amount of returned goods $($labeled as ReturnedGoodsValue$)$ and total number of returned transactions $($labeled as ReturnedGoodsCount$).$

$11.$ Compute the amount of sales tax for each transaction that would have been paid if OSU were required to pay sales tax in December $2014.$ The state sales tax rate is $4\mathrm{.}5\%.$ Display the month,

year, cardholder name, description, vendor name, amount and computed sales tax amount $($labeled SalesTax$).$ Sort by the sales tax amount so the largest items appear on the top.

$12.$ The university would like to know how much money it saved by not paying state sales tax. The state sales tax rate is $4\mathrm{.}5\%.$ If you assume all sales are made net of the state sales tax, how much money did OSU avoid paying in sales tax to the government on P$-$card transactions for each calendar year?

Show the year, total amount spent and total amount saved in sales tax $($label as SalesTaxSaved$).$ Make sure to round dollar figures to the nearest cent using the Property Sheet, Format field $($use the

currency format$)$ rather than using a formula. Sort the data by year with the most recent year listed

first.