Using the database that was created and used in Exercise $2,$ create queries to answer the following questions. Note: you will have at least one query per question. Make sure to save them as Answer $1,$ Answer $2,$ etc.

How many sales did each salesperson sale on a Monday?

Answer $1$

Answer $2$

$2.$ What salespeople sold dryers? Include who they sold the dryer to and on what date.

Answer $1$

Answer $2$

$3.$ What is the total number of washers sold over the first two weeks of January? $($Hint: The first two weeks refer to between January $1$st and $14$th$.$ Also "total number" refers to washer units not numbers of sales. Some sales included more than one unit$).$

Answer $1$

Answer $2$

$4.$ Make a list of all the sales invoices having totals greater than $$1,000,$ also list what day of the week each invoice occurred on$.$ Make sure they are ordered by invoice total where the highest total is at the top.

Answer $1$

Answer $2$

$5.$ Make a list of salespeople who made no sales on a Monday $($Hint: your answer to question $1$ is a good starting point$).$

Answer $1$

Answer $2$