In this assessment, students will show mastery with the SELECT statement -- the focus is on JOIN and GROUP BY. You are a

[answerhappygod]

In this assessment, students will show mastery withthe SELECT statement -- the focus is on JOIN and GROUP BY.
You are an analyst for Momot Trailer Sales. John, the owner, hasshown you two reports that were created based on the sale of newtrailers for 2017 (see below). The previous analyst was notvery good at making reusable code or saving code so the SQL codethat produced those reports is not available. The owner wouldlike you to recreate the reports using the Trailer Salesdatabase. The first report shows the units sold and thedollar amount for Body Type. The second query does the samefor the sales team. Your reports should be based on sales in2018. John also mentioned that new units are identified inthe NUD column with an "N" and that signing date indicated the datethat we sold the trailer.
2017 Report Samples
Brian
Rules/Assumptions
Your submission must comply with the following list ofrules/assumptions. Violating the rules and assumptions willresult in a grade reduction and in some cases a zero on theassignment.