Rank ICU covid occupancy by state for the most recent date available

Custom SQL query returning 54 rows (hide)

select state, date, 100*(staffed_icu_adult_patients_confirmed_and_suspected_covid)/(total_staffed_adult_icu_beds) as icu_adult_prnct, total_staffed_adult_icu_beds as tot_adult_icu_beds, staffed_icu_adult_patients_confirmed_and_suspected_covid as tot_adult_icu_covid from hospitals_state where date == '2022/07/01'  order by icu_adult_prnct desc;

Edit SQL