SELECT SUM(Sales.Amount) AS TotalSales, Products.Name AS ProductName, Customers.Name AS CustomerName FROM Sales JOIN Products ON Sales.ProductID = Products.ID JOIN Customers ON Sales.CustomerID = Customers.ID WHERE Sales.Date >= DATEADD(quarter, -1, GETDATE()) GROUP BY Products.Name, Customers.Name;

SELECT Sales.Amount AS TotalSales, Products.Name AS ProductName, Customers.Name AS CustomerName FROM Sales JOIN Products ON Sales.ProductID = Products.ID JOIN Customers ON Sales.CustomerID = Customers.ID WHERE Sales.Date >= DATEADD(quarter, -1, GETDATE());

SELECT SUM(Sales.Amount) AS TotalSales, Products.Name AS ProductName, Customers.Name AS CustomerName FROM Sales JOIN Products ON Sales.ProductID = Products.ID JOIN Customers ON Sales.CustomerID = Customers.ID GROUP BY Products.Name, Customers.Name;

SELECT Sales.Amount AS TotalSales, Products.Name AS ProductName, Customers.Name AS CustomerName FROM Sales JOIN Products ON Sales.ProductID = Products.ID JOIN Customers ON Sales.CustomerID = Customers.ID;