samcapable-purple
Updated 2024-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
-- select
-- reward, -- need to sum to get total puzzle reward for the block
-- reward*3/2 as coinbaseReward -- variable that changes depending on the block puzzle difficulty every epoch (360 blocks )
-- block_puzzle_reward
-- from aleo.core.fact_block_solutions
-- where block_id = 1296028
-- limit 10
-- PuzzleReward = CoinbaseReward * 2/3
-- BlockReward = 23.8 + CoinbaseReward * 1 / 3
--select * from ethereum.core.ez_token_transfers where tx_hash = '0xfff2da4f7876accfe05b5b5c37b044c3138562d8f7e9ba2cab44f4d40d4b800b'
-- select * from aleo.core.fact_blocks
-- where block_id = 1296028
select * from aleo.core.fact_blocks
where block_reward / pow(10,6) < 24
and block_reward / pow(10,6) <> 23.782343
QueryRunArchived: QueryRun has been archived