Guest User

RC Query Group

a guest
Aug 7th, 2024
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. SELECT
  2.   series_name,
  3.   creators,
  4.   item_id,
  5.   addresses,
  6.   total_value,
  7.   balance,
  8.   first_active,
  9.   redeemed_on
  10. FROM
  11.   god_view
  12. WHERE
  13.   creators LIKE '%Rarity Check%' AND
  14.   redeemed_on IS NOT NULL AND
  15.   redeemed_on IN (
  16.     SELECT redeemed_on
  17.     FROM god_view
  18.     WHERE creators LIKE '%Rarity Check%' AND redeemed_on IS NOT NULL
  19.     GROUP BY redeemed_on
  20.     HAVING COUNT(*) >= 3
  21.   )
Advertisement
Add Comment
Please, Sign In to add comment