, case when at.app_id in (776179559,776176449,752770929,751285119,747239433,747237154,743685742,743679535,696044550,694464549,694405065,686876641,686875498,686862190,686860954,686501760,686500844,686500029,686498781)

then 'Folks Finance'

when at.app_id in (649588853,350338509,552635992)

then 'Tinyman'

when at.app_id in (705663269,705657303,674527132,661247364,661207804,661204747,661199805,661193019,661192413,659678644,659677335,658337046,658336870,647785804,647785158,641500474,641499935,639747739,639747119,611869320,553866305,482625868,465814222,465814065,674526408,637795072,637793356,635866213,635864509,635863793,635860537,635813909,635812850,611867642,611804624,611801333,605753404,553869413,482608867,465818260,465814318,465814278,465814149,465814103)

then 'AlgoFi'

when at.app_id in (354073718,354073834)

then 'AlgoDEX'

else 'Other' end app

, sum(at.fee) total_algo_fee_app_call

, count(distinct at.tx_id) transaction_ct_app_call

from flipside_prod_db.algorand.application_call_transaction at

where at.block_timestamp >= date('2021-04-01')

group by 1,2