The information in C was not very informative since only customer_id was included. Write a new query (feel free to start with the query you created in part C) that includes an inner join to show customer_last_name rather than customer_id. Your query should therefore include order_id, customer_last_name, order_date and shipped_date formatted as in part C. Sort your query by customer last name. E. This time we would also like to know what items each customer purchased. Improve your query by showing the entire customer name (your concatenation from # 2) instead of last name. Then add item_id and order_qty with a join to the order_details table. Give each an appropriate alias. Sort your result by customer last name then quantity. F. Next, you guessed it... we want to replace the item number with the artist and title as well as add the unit_price from the items table. To accomplish this, add an additional join that includes the items table. Joins can get quite extensive as we add additional tables to our output. You should still include all fields from part E as well as the additional output indicated in this step. G. Write a query that shows the Total (price* quantity) of all orders that have not yet shipped. For this query you can continue with part F and add a WHERE clause with the criteria that shipped_date is null. Take a screenshot showing your comments, code, sample output and action output.