To Optimize `orders_summary_view.sql`

orders_summary_opt_view.sql

CREATE VIEW `order_summary_opt` AS
SELECT
oo.OrderID as OrderID, 
oo.CustomerID as CustomerID, 
oo.EmployeeID as EmployeeID, 
oo.OrderDate as OrderDate, 
oo.RequiredDate as RequiredDate, 
oo.ShippedDate as ShippedDate, 
oo.ShipVia as ShipVia, 
oo.ShipName as ShipName, 
oo.ShipAddress as ShipAddress, 
oo.ShipCity as ShipCity, 
oo.ShipRegion as ShipRegion, 
oo.ShipPostalCode as ShipPostalCode, 
oo.ShipCountry as ShipCountry, 
oo.Freight as Shipping,
COUNT(*) as TotalItems,
SUM(od.UnitPrice * od.Quantity) as TotalAmount,
SUM(od.UnitPrice * od.Quantity * od.Discount) as TotalDiscount,
SUM(od.UnitPrice * od.Quantity * (1 - od.Discount)) as DiscountedAmount,
SUM(od.UnitPrice * od.Quantity * (1 - od.Discount)) + oo.Freight as GrandTotal
FROM orders oo
JOIN order_details od
	ON oo.OrderID = od.OrderID
WHERE 1 = 1
GROUP BY OrderID, CustomerID, EmployeeID, OrderDate, 
RequiredDate, ShippedDate, ShipVia, ShipName, ShipAddress, ShipCity, 
ShipRegion, ShipPostalCode, ShipCountry, Shipping
;