Worked!
But I wonder where they'll get a million users that meet the conditions: D
SELECT COUNT(*)
FROM Accounts AS a
WHERE a.reputation > 0 AND CONVERT(DECIMAL(7, 3), (LOG(ABS(a.reputation), 10) - 9) * 9 + 25) >= 30
Result:
154203
Worked!
But I wonder where they'll get a million users that meet the conditions: D
SELECT COUNT(*)
FROM Accounts AS a
WHERE a.reputation > 0 AND CONVERT(DECIMAL(7, 3), (LOG(ABS(a.reputation), 10) - 9) * 9 + 25) >= 30
Result:
154203
RE: Official Byteball Airdrop to Steemians