Most everyone got 4 of the 5 queries. #4 was the tricky one, and no one got it entirely right. For this one, you needed the OrderDetails table (only), from which you select OrderID and (unitPrice * quantity), grouping by OrderID and Summing (unitPrice*quantity).
As usual, I accepted just about everything here, so long as you built something that made sense and did it properly.