Comment by sontek

SELECT COUNT(*) FROM users WHERE date_deleted IS NULL AND date_last_activity >= CURRENT_DATE - INTERVAL '120 days';