This assignment deals with multidimensional querying in a data warehouse (AdventureWorkdsDW)

The finance department wants to be able to project future financing details. The department manager sent you a request for a rolling 3 month average on past financials. Develop the SQL query code used to explore the database tables and write a query that retrieves finance amounts from "FactFinance" in the AdventureWorkdsDW database and returns those amounts organized by month and showing a 3-month rolling average.

Table Name - FactFinance

Table Columns - FInanceKey, Date Key, Organization Key, DepartmentGroupKey, ScenarioKey, AccountKey, Amount, Date