I wonder... who has sent the most hive to exchanges?

For a while I have thought that transparency is a good thing. The below SQL query can be enhanced and ran on HAF SQL Servers. The idea is to target exchange accounts, then aggregate the total hive sent to them by users. The SQL query outlines the parameters, the table below it is the results of a quick query ran. Feel free to enhance it and discuss among yourselves.

I've been busy with a full time job and haven't been doing much hive stuff, but this is a burning question I've always had. I don't have time to improve this, but feel free to go and do it yourself. :)

I come in at 930. I skipped a few of the columns in the output of this table. The script is messy, as I said earlier, happy for other people to improve it.

    SELECT 'deepcrypto8' AS account
    UNION ALL
    SELECT 'binance'
    UNION ALL
    SELECT 'huobiglobal'
    UNION ALL
    SELECT 'kraken'
    UNION ALL
    SELECT 'upbit'
    UNION ALL
    SELECT 'coindcx'
    UNION ALL
    SELECT 'bitfinex'
    UNION ALL
    SELECT 'okx'
    UNION ALL
    SELECT 'gateio'
    UNION ALL
    SELECT 'kucoin'
    UNION ALL
    SELECT 'bittrex'
    UNION ALL
    SELECT 'poloniex'
    UNION ALL
    SELECT 'mxchive'
    UNION ALL
    SELECT 'binance-hot'
    UNION ALL
    SELECT 'bithumb.hot'
    UNION ALL
    SELECT 'exchangeme'
    UNION ALL
    SELECT 'coinexhot'
    UNION ALL
    SELECT 'gopax-deposit'
)
SELECT
    from_account AS sender,
    SUM(CASE WHEN symbol = 'HIVE' THEN amount ELSE 0 END) AS total_hive,
    SUM(CASE WHEN symbol = 'HBD' THEN amount ELSE 0 END) AS total_hbd,
    COUNT(*) AS tx_count,
    STRING_AGG(DISTINCT memo, ' | ') AS sample_memos
FROM
    hafsql.operation_transfer_table t
JOIN
    target_accounts ta ON t.to_account = ta.account
GROUP BY
    from_account
ORDER BY
    (SUM(CASE WHEN symbol = 'HIVE' THEN amount ELSE 0 END) + SUM(CASE WHEN symbol = 'HBD' THEN amount ELSE 0 END)) DESC;