Write a SELECT statement to summarize sales by store state, month, and year.The result without using the GROUPINGSETS operator in your SQL statementshould 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$).$