DB small task

MegaOmniCorp sells flipwidgets to Canadian consumers. It has a number of salespeople who manage sales territories. Each salesperson has their own Quota which may vary over time depending on market conditions. MegaOmniCorp uses a machine learning algorithm to set the sales quota for each sales person and territory based on a number of inputs including sales data over time. Additionaly, management will leverage sales data to set compensation levels for their sales people. The machine learning algorithm requires a data feed that provides the number of products sold per product per salesorder per sales person per territory. Management requires a report that provides the total amount sold YTD per salesperson per territory.