COVID-19 public dataset focusing on: Texas
Where is Texas in the number of states compared to the other states?Pretty high.
SELECTstate_name, confirmed_cases, deaths, round(deaths/confirmed_cases,4) as death_rateFROM `bigquery-public-data.covid19_nyt.us_states` where date in (select max(date) from…