Database: Database: AdventureWorksDW

Tables: fact call center

Schema: dbo

Need: build and test the SQL to answer this question: what is the total number of issues raised $($provide suitable column headers$)?$ DO NOT sort the data unless explicitly asked to$.$

part $2$

database: database: AdventureworksDW

tables: fact call center

schema: dbo

need: build and test the sql to answer this question in a single sql statement. I need to see the average number of calls per shift. You should also display the average across shifts in the last row $($do not sort the data unless explicitly asked to$)$