Query editor
WITH data AS (SELECT CASE WHEN d.entity = 'Kiln' THEN get_href('https://x.com/Kiln_finance', d.entity)WHEN d.entity = 'Diva (Pre-launch)' THEN get_href('https://x.com/divastaking', d.entity)WHEN info.x_username IS NOT NULL THEN get_href('https://x.com/' || info.x_username, d.entity)WHEN d.entity IS NULL THEN 'Unidentified'ELSE d.entity END AS entity, SUM(amount_staked-amount_full_withdrawn) AS stakedFROM query_2393816 dLEFT JOIN staking_ethereum.info info ON info.entity=d.entityWHERE amount_staked+amount_full_withdrawn > 0AND entity_category = 'CEXs'AND validator_index >= 0GROUP BY 1)SELECT entity, staked, staked/(SELECT SUM(staked) FROM data) AS marketshareFROM dataORDER BY 2 DESC