write SQL to display

1. Summarized TotalAmount by Year, Region, Customer, ProductFamily

2. Summarized TotalAmount and TotalAmountCommision by Year, Manager, Agent

3. Year, AgentName, Product Family Description, and Total Sales Amount (summarized amount)

4. Year, ManagerName, Product Family Description, and Total Sales Amount( summarized amount)

so_REGION PK RegionID RegionName SO_PRODUCT_FAMILY PK ProductFamilyID ProductFamily ProductUnitPrice SO_MARKET PK MarketID MarketName FK CustomerID PK SO_PRODUCT ProductID ProductDescription ProductFamilyID ProductUnitPrice FK so_CUSTOMER PK Customer_ID CustomerName CustomerPhone CustomerEmail Customer Address FK MarketiD FK RegionID PK so_ORDER OrderID Order Date CustomerID ProductID Quantity AgentID FK FK FK SO_SALES_AGENT PK AgentiD AgentName ManagerID so_MANAGER PK ManagerID ManagerName CommissionPercent