Step $\backslash$#$8$: Plant manager is not happy regarding shipments that have not been delivered. Run a query to display customers that have pending shipments. Your report must include last name as "Last Name", first name as "First name", and shipping id as "Shipment Number". Notice: you do not have a common field name and will be unable to use the natural join. $($remember$..$ you cannot use table name alias$).$ Once completed, submit your screenshot that includes the Input and Output areas to your Microsoft Form.

Step $\backslash$#$9$: Opps... you forgot what you ordered. Run a query that shows only what you ordered. Your output must include only your last name, first name, order id$,$ items, and dollar amount. Once completed, submit your screenshot that includes the Input and Output areas to your Microsoft Form.

Step $\backslash$#$10$: We are an international company. Your boss would like to have a report that shows the total purchased by country with totals by the shipment status. The query needs to include country, status, total of amount summarized by the country with a separate total for status named as Total Purchase.

Notice: you have an error in your database with Customer $\backslash$#$5.$ This customer has a pending shipment but no order. You must exclude customer $\backslash$#$5$ in your code. $($Hint: your output needs to look like the following$)$