Write SQL to display :

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

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

Tables are:

Managerlo ManagerName 10 Jack Dorman 20 Julia Bell 30 Hans Gruber 40 John Travolta 50 Shelly Stone CommissionPercent 2.55 0.85 0.65 0.54 1.02 Managerlo ManagerName 10 Jack Dorman 20 Julia Bell 30 Hans Gruber 40 John Travolta 50 Shelly Stone CommissionPercent 2.55 0.85 0.65 0.54 1.02