Write a SELECT statement to summarize sales by store state, month, and year.The result should compute the SUM of dollar sales for the years $2020$ and $2021.$The result should include store state totals concatenated to partial totals in orderof the hierarchical dimension $($year and month$).$ Do not use the GROUPINGSETS operator in your SQL statement