Query editor
-- 2번 쿼리: 수정된 버전WITH sector_analysis AS (SELECTCASEWHEN value / 1e18 >= 1000 THEN 'Institutional (>1000 ETH)'WHEN value / 1e18 >= 100 THEN 'Large Scale (100-1000 ETH)'WHEN value / 1e18 >= 10 THEN 'Medium Scale (10-100 ETH)'WHEN value / 1e18 >= 1 THEN 'Small Scale (1-10 ETH)'ELSE 'Micro (<1 ETH)'END as sector,COUNT(*) as transaction_count,COUNT(DISTINCT "from") as unique_borrowers,SUM(value / 1e18) as total_volume_eth,AVG(value / 1e18) as avg_tx_size_ethFROM ethereum.transactionsWHERE block_time >= now() - interval '7' dayAND value / 1e18 >= 0.1AND success = trueGROUP BYCASEWHEN value / 1e18 >= 1000 THEN 'Institutional (>1000 ETH)'WHEN value / 1e18 >= 100 THEN 'Large Scale (100-1000 ETH)'WHEN value / 1e18 >= 10 THEN 'Medium Scale (10-100 ETH)'WHEN value / 1e18 >= 1 THEN 'Small Scale (1-10 ETH)'ELSE 'Micro (<1 ETH)'END)SELECTsector,transaction_count,unique_borrowers,ROUND(total_volume_eth, 2) as total_volume_eth,ROUND(avg_tx_size_eth, 2) as avg_tx_size_eth,ROUND(transaction_count * 100.0 / SUM(transaction_count) OVER(), 2) as tx_percentage,ROUND(total_volume_eth * 100.0 / SUM(total_volume_eth) OVER(), 2) as volume_percentageFROM sector_analysisORDER BY total_volume_eth DESC;