I'm looking for some assistance/guidance on creating an sql function that will count actions that begin with a certain key. So, within a date range, if a constituent has 10+ of a specific action recorded, they get one score. If they have between 5 and 9, they get another score, etc.
Thank you again. Your join statements got me going in the right direction.