$(1)$ For which items are there at least $5$ units in quantity on hand?

$(2)$ List the invoice number, dates, and salesperson for sales made to Rodney Wern.

$(3)$ List the dates, description, and quantality for each transaction in which Stainless$-$color appliances were sold in October.

$(4)$ List description and sum of quantity of inventory types that sold $2$ or more units in October.

$(5)$ List sale date and invoice total for each invoice in October.

$(6)$ List total sales $($$$)$ by salesperson in October, sort by largest sales amount to smallest.

$(7)$ Report total sales $($$$)$ by state.

$(8)$ Compute the markdown for each item sold. Calculate markdown as $($SoldPrice$-$ListPrice$)/$ListPrice$.$ List description, color, and average markdown by types and colors, sort by largest average markdown $($most negative$)$ to smallest.