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:

the year is provided in the order table shown under OrderDate. Table names are: so_CUSTOMER, so_MANAGER, so_MARKET, so_ORDER, so_PRODUCT, so_PRODUCT_FAMILY, so_REGION, so_SALES_AGENT.

Thanks!

ManageriD AgentiD AgentName 101 Scooby 102 Quickshot Jim 103 Speedy Gonzalez 104 Nikita Kruschev 105 Jimmy Carter 10 20 30 40 50 ProductFamilyID ProductFamily 10 TVs and Videogames 20 Sofas and Tables 30 Collectibles 40 Fragrances 50 Clothing and Shoes 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 OrderID OrderDate 30000 2010-11-27 30001 2010-10-12 30002 2010-05-13 30003 2010-08-19 30004 2010-04-21 30005 2010-12-21 30006 2010-05-11 30007 2010-05-21 30008 2010-01-19 30009 2010-02-13 30010 2012-02-28 30011 2012-08-08 30012 2012-08-09 30013 2012-11-10 30014 2012-07-13 30015 2012-10-19 30016 2012-11-09 30017 2012-08-11 30018 2012-07-13 30019 2012-01-17 30020 2014-08-19 30021 2014-09-18 30022 2014-10-17 30023 2014-05-20 30024 2014-05-21 30025 2014-05-22 30026 2014-05-09 30027 2014-05-21 30028 2014-12-24 30029 2014-05-11 30030 2016-06-23 30031 2016-08-21 30032 2016-12-21 30033 2016-05-13 30034 2016-11-19 30035 2016-05-21 30036 2016-08-16 30037 2016-05-21 30038 2016-05-06 30039 2016-09-21 30040 2018-05-05 30041 2018-03-21 30042 2018-05-09 30043 2018-05-16 30044 2018-12-19 30045 2018-11-21 30046 2018-01-21 30047 2018-05-11 30048 2018-08-19 30049 2018-09-28 Customerid 1220 1225 1215 1218 1220 1219 1224 1220 1211 1215 1217 1221 1222 1223 1219 1220 1221 1211 1214 1216 1218 1219 1218 1211 1212 1213 1223 1220 1216 1215 1214 1225 1211 1214 1220 1219 1213 1215 1225 1211 1211 1217 1215 1218 1212 1224 1213 1218 1219 1220 ProductID Quantity AgentiD 110 2 103 110 100 105 240 25 101 180 18 102 130 7 103 210 11 105 190 14 102 130 16 103 110 20 101 250 40 105 150 3 105 160 6 101 150 4 105 140 2 105 110 11 101 190 20 102 180 25 104 220 7 105 210 17 104 200 50 103 110 13 101 250 8 102 240 4 104 180 3 105 190 200 105 200 33 105 160 43 102 130 10 103 130 33 103 110 1000 110 9 101 180 120 102 240 15 105 220 1500 101 130 10 103 150 8 105 160 30 104 200 5 101 170 5 102 110 1000 101 200 55 101 210 5 101 120 2000 101 170 55 103 200 100 102 250 15 104 110 10 101 150 30 102 190 100 103 130 15 103 101 ProductFamilyID ProductID ProductDescription 180 XBOX Series X 200 Wooden Table 150 VIZIO SQ650U 140 Titanfall 160 SHARP 6200 170 Playstation 5 250 Nike Air 130 halo 3: Fall of Reach 120 Halo 2 110 Halo 210 Foldable Table 190 Corner Couch 230 Basketball Cards 220 Baseball Cards 240 Armani ProductUnitPrice 10 499.99 20 5000.55 10 899.00 10 19.99 10 989.99 10 499.99 50 120.25 10 49.99 10 19.99 10 50.99 20 199.99 20 1799.99 30 1595.89 30 3500.66 40 199.99