Updated 2022-09-02
    select count(distinct FROM_ADDRESS) as fans ,txs
    from (select
    FROM_ADDRESS , count(distinct tx_hash) as txs

    from optimism.core.fact_transactions

    where TO_ADDRESS=LOWER('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')
    group by 1 )
    group by 2
    Run a query to Download Data