![]() ![]() A region with no sales should be also returned. The difference between the average sales of the region with the highest average sales, and the average sales per employee for the region (average sales to be calculated as explained above).Įmployees can have multiple sales. ![]() Average sales per employee for the region (Average sales = Total sales made for the region / Number of employees in the region).Management requires a comparative region sales analysis report. The following tables contain the data: TABLE regionsįOREIGN KEY (regionId) REFERENCES regions(id)įOREIGN KEY (stateId) REFERENCES states(id)įOREIGN KEY (employeeId) REFERENCES employees(id) An insurance company maintains records of sales made by its employees. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |