Query editor
1SELECT2 project,3 SUM(volume_usd) AS volume_usd,4 COUNT(*) AS transfer_rows5FROM query_86319116WHERE project IS NOT NULL AND LOWER(project) <> 'unknown'7GROUP BY 18ORDER BY volume_usd DESC9LIMIT 15
SELECT
project,
SUM(volume_usd) AS volume_usd,
COUNT(*) AS transfer_rows
FROM query_8631911
WHERE project IS NOT NULL AND LOWER(project) <> 'unknown'
GROUP BY 1
ORDER BY volume_usd DESC
LIMIT 15