i would calculate the difference between their registration date and their last login. then i would add an extra criteria to make sure out of those the registra

i would calculate the difference between their registration date and their last login. then i would add an extra criteria to make sure out of those the registration date is at least a month old so you would get the number of active users in the past month who are not new registers. it's a pretty simple sql query.