SQL Report Test

SELECT town, count(town)
FROM   wp_participants_database WHERE membstatus LIKE 'adult member' OR membstatus LIKE 'adult guest' OR membstatus LIKE 'junior cadet' GROUP BY town