I need help fast. I need an SQL query for the following request
In the attached table I highlighted specific columns that represent sectors. I need to know for each Unique Agency, How many of these sectors are represented. For example, if the agency "Albany Park" has at least one row with the sector Police then that counts as one sector represented for the time period. I need to know for each of these Agencies which sectors were at least represented at some point or basically the ones that have a "1" in it.