1. Navigate to Analysis>Information Library
  2. Click Add ad-hoc query and select source view of Constituents
  3. From the left, expand Member> select Membership> from middle column, drag Status to Include Records where> Set equal to Active
  4. From the left, select Constituents> from middle column, drag Deceased to Include records where> set equal to No
  5. From the left, click on Address (Primary)> From the middle, drag Zip into Results fields to display
  6. Drag Zip into Results fields to display a Second time> highlight this item in results fields to display> click the Sigma button and select Count

Your final query should look similar to below:
active members by zip code