SELECT count(DISTINCT region_id) FROM affected_region
How many regions are affected?
SELECT count ( DISTINCT region_id ) FROM affected_region
select count ( distinct region_id ) from affected_region
How many regions are affected ?