USE [Northwind]
GO

/****** Object:  StoredProcedure [dbo].[Employee Sales by Country]    Script Date: 1/20/2023 9:54:20 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE procedure [dbo].[Employee Sales by Country] 
@Beginning_Date DateTime, 
@Ending_Date DateTime
AS
SELECT 
	Employees.Country, 
	Employees.LastName, 
	Employees.FirstName, 
	convert(varchar(10), Orders.ShippedDate, 101) AS Shipped, 
	Orders.OrderID, 
	convert(Decimal(8,2),"Order Subtotals".Subtotal) AS SaleAmount

FROM Employees 
	INNER JOIN (
			Orders 
			INNER JOIN "Order Subtotals" 
				ON Orders.OrderID = "Order Subtotals".OrderID
			) 
			ON Employees.EmployeeID = Orders.EmployeeID
WHERE Orders.ShippedDate 
	--Between @Beginning_Date And @Ending_Date
		BETWEEN '01-01-1998' AND '01-31-1998'
ORDER BY 
Employees.Country, 
Employees.LastName, 
Employees.FirstName, 
YEAR(Orders.ShippedDate) DESC,
MONTH(Orders.ShippedDate) DESC,
DAY(Orders.ShippedDate) DESC,
SaleAmount DESC
			
GO