$3.$ We need a listing of all sales orders that have not been invoiced. Please show the order number, the order date, the customer name, the expected shipping date, and the salesperson name for these un$-$invoiced sales orders.

$4.$ We offer a standard discount to orders from auto parts stores. For such orders, the discount percentage for each product ordered is shown in the "products$\_$ordered" table. I would like to know the combined sum total dollar value of the discounts for all product sales for which a discount was applied, that is$,$ product sales orders to auto parts stores.

$5.$ We need to determine the frequency of usage of each of the two shipping companies we use. How many orders are assigned $($in the orders table$)$ to the shipper UPS versus the shipper Tampa Tracking? A simple count for each will suffice.

Need the queries for those please