RC Query Group

SELECT
  series_name,
  addresses,
  serial,
  total_value,
  balance,
  first_active,
  redeemed_on
FROM
  god_view
WHERE
  creators LIKE '%Rarity Check%' AND
  redeemed_on IS NOT NULL AND
  redeemed_on IN (
    SELECT redeemed_on
    FROM god_view
    WHERE creators LIKE '%Rarity Check%' AND redeemed_on IS NOT NULL
    GROUP BY redeemed_on
    HAVING COUNT(*) >= 3
  )
 ORDER BY series_name, CAST(serial AS INTEGER) ASC;