need help to write some code. mysqlhelp me write the code i have my code written out but just need to check it.

3. Report how many counties are in each state. Show State Name, Number of Counties. Sort the display by state. 4. Which are the ten counties in the US that reported highest 7-day average of cases on Dec 15, 2022? The query output should show these columns: Date, County, State, 7-Day Moving Average of Daily Cases. The labels/headers of columns in the query output should match the labels in the question. 5. Which are the five states that have reported highest number of total cases in the year 2021 ? The query output should show these columns: State, Total Cases in 2021. The labels/headers of columns in the query output should match the labels in the