with tbl AS

SELECT

date_trunc(day, block_timestamp) as date,

count(DISTINCT from_address) as "Daily addresses",

count (DISTINCT tx_hash) as "Daily tx"

from swell.core.fact_transactions

GROUP by 1

SELECT

date,

"Daily tx"/"Daily addresses" as "Daily avg tx per address"

from tbl