In SQL, you can use the following command: select active_status, count(*) as number from DallasData group by active_status;