date_trunc('day', block_timestamp) as days,

(count(distinct tx_group_id) / (select count(distinct tx_group_id) from flipside_prod_db.algorand.application_call_transaction))*100 as percent

from algorand.application_call_transaction

where app_id in (

649588853, 350338509, 552635992

)

and days>='2022-01-01'

group by 1, 2