Miscellany

Select	C.First_Name+' '+C.Last_Name "Customer Name",
	E.First_Name+' '+E.Last_Name "Employee Name",
	CO.Order_Date "Order Date",
	CO.Item_Total "Item Total",
	SC.Shipping_Charge_Amount "Shipping Charge",
	CO.GST_Amount "GST Amount"
From	Employees E inner join Customer_Orders CO
	On E.Employee_Number = CO.Employee_Number
	inner join Customers C
	On CO.Customer_Number = C.Customer_Number,
	Shipping_Charges SC inner join Customer_Orders
	On SC.Shipping_Charge_Code = Customer_Orders.Shipping_Charge_Code
	and Datediff(day, Customer_Orders.Order_Date, GetDate()) <=365
Group By C.First_Name, C.Last_Name, E.First_Name, E.Last_Name,
	CO.Order_Date, CO.Item_Total, SC.Shipping_Charge_Amount,
	CO.GST_Amount
Order By CO.Order_Date