D$.$ 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.

I have part C done, when i try to JOIN, I keep getting an error messege.

$($SELECT date$\_$format$($order$\_$date, $\text{'}\%$M$/\%$D$/\%$Y$\text{'})$ AS OrderDate,

date$\_$format$($shipped$\_$date, $\text{'}\%$M$/\%$D$/\%$Y$\text{'})$ AS ShippedDate,

order$\_$id$,$

customer$\_$id

FROM orders$)$