output is already provided just need the code! thanks

8. Compare Mortality Ratio of US states by year (i.e 2020, 2021, 2022). Show: State, Year, Mortality Ratio. Sort the output first by state, then by year. 9. Show the cumulative cases and deaths, and the mortality ratio aggregated by state. The query output should show these columns: State, Cumulative Cases, Cumulative Deaths, Mortality Ratio. 10. Look up the data for the Hidalgo County for Jan 1, 2023. Insert the relevant columns in the counties and the states tables. The data can be found here: https://github.comytimes/ covid-19-data. The SQL syntax to insert a row is something like: INSERT INTO county VALUES (field-1, field-2, field-3 ...); . Check https://dev.mysql.com/doc/refman/8.0/en/insert.html for more information on syntax