Step $\backslash$#$5$: Shipping manager needs to have confirmation at the end of each day to show all the shipments that have been delivered. Create a query to show all the fields from the Shippings table with the label of delivered. Must be sorted descending by customer number. Once completed, submit your screenshot that includes the Input and Output areas to your Microsoft Form.

Step $\backslash$#$6$: Your boss would like a report to show what product items have been ordered. Create a list of items with no repeating item names. The list needs to show the items in ascending order and their average dollar amount plus $\backslash (\backslash$$ $10\backslash )$ markup. The name of this new calculated column needs to be "Markup". Once completed, submit your screenshot that includes the Input and Output areas to your Microsoft Form.

Step $\backslash$#$7$: Create a report to show all the orders that a customer with the first name of John ordered. Report must display customer's first name, last name, customer id$,$ order id$,$ items ordered. Sort by customer id ascending. $($Hint: try a natural join and remember... you cannot use table name alias$).$ Once completed, submit your screenshot that includes the Input and Output areas to your Microsoft Form.