Database SQL Select and Join Query

Stuck on the last part of this homework, I'll submit all my code so far, I feel good about my code but any changes are welcome, but mostly focusing on the last part of the homework.

BE SURE TO INCLUDE all of the fields from the donut sales order form in your normalization 

design and complex join query EXCEPT the calculated attributes/fields

(Line Total, Subtotal, 

Sales Tax and Total)