No need for the output, just the syntax.

For each order placed on August 18^th, 2019, how many unit items (a unit item is 1 vacuum cleaner; two of the same model would be 2 unit items; one of one model and one of another would also be 2 unit items) were purchased? Output only those orders that included two or more unit items, include in your output the order number and the number of unit items, and order your output by order number (lowest to highest). (Hint: you will need two tables, SalesOrder and OrderLine.) (Remember: only copy the top 10 rows do not worry about the Headers or Copy with Headers).

What is the total value of all orders placed for each region? The output should include the name of the region as well as the total value of all orders placed there. Order results alphabetically by region. (Hint: the USState table and the Customer table will need to be part of your query.) Based on these results, to which region do you think the company marketed most heavily during the early part of August 2019?

Which three customers bought the highest number of MadHare units during the period covered by the database? Your output should include first name, last name, and the number of units purchased and should include information only about the three customers with the highest number of MadHare units. Be sure your query references the Model table (i.e., do not look up the model number for MadHare, instead include in your query content that figures out which records refer to MadHare).