84%

INSERT INTO [Orders Archive] (OrderID, CustomerID, EmployeeID, ShippedDate, ShipVia, Freight, ShipCountry, mSysRowId) SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipCountry, Orders.mSysRowId FROM Orders WHERE (((Orders.ShippedDate) Between #4/1/2020# And #6/30/2020#));

SELECT Customers.CustomerID, Customers.CompanyName, Customers.ContactName, Customers.Address, Customers.City, Customers.PostalCode, Customers.Country, Customers.Phone FROM Customers;

DELETE Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipCountry, Orders.mSysRowId FROM Orders WHERE (((Orders.ShippedDate) Between #1/1/2020# And #6/30/2020#));

SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipCountry, Orders.mSysRowId INTO [Orders Archive] FROM Orders WHERE (((Orders.ShippedDate) Between #1/1/2020# And #3/31/2020#));

SELECT [Order Details].Quantity, [Order Details].Discount, Products.UnitPrice, Products.ProductCost, Categories.CategoryName, Orders.ShippedDate, Orders.ShipCountry, [UnitPrice]*(1-[Discount])*[Quantity]-[ProductCost]*[Quantity] AS Profit, Employees.LastName FROM (Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID) INNER JOIN ((Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID) INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID) ON Orders.OrderID = [Order Details].OrderID;

TRANSFORM Sum(Profit.Quantity) AS SumOfQuantity SELECT Profit.CategoryName, Sum(Profit.Quantity) AS [Total Of Quantity] FROM Profit GROUP BY Profit.CategoryName PIVOT Profit.LastName;

UPDATE Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID SET Products.UnitPrice = [UnitPrice]*1.06 WHERE (((Categories.CategoryID)=6));