--Number of user who have the goal BPN5 for each status select count(*) from wnp_member_goals t where t.goal_unique_id='BPN5' and t.status='Recommended' select count(*) from wnp_member_goals t where t.goal_unique_id='BPN5' and t.status='Selected' select count(*) from wnp_member_goals t where t.goal_unique_id='BPN5' and t.status='Achieved'