with total_sum as (
SELECT
SUM(BALANCE_USD) as total_sum
from terra.daily_balances where currency='LUNA' AND BALANCE_TYPE='liquid' AND date='2022-01-27'
)
Select
ADDRESS
, SUM(BALANCE_USD) AS SUM_BALANCE_USD
, SUM(BALANCE_USD)/(select total_sum from total_sum)*100 AS PERCENTAGE_OF_CIRCULATING_SUPPLY
from terra.daily_balances where currency='LUNA' AND BALANCE_TYPE='liquid'
GROUP BY ADDRESS
ORDER BY 2 desc
LIMIT 5