select count(*) from failed_banks;

select state_, count(*) as num from failed_banks group by state_ order by num desc limit 5;

select city_, count(*) as num from failed_banks group by city_ order by num desc limit 5;

select date_part('year', to_date(closing_date_, 'dd-MON-yy')) as closing_yr,
	count(*) as closing_by_year
    from failed_banks group by closing_yr
    order by closing_yr desc;