COUNT(DISTINCT TX_HASH) as users

FROM optimism.velodrome.ez_lp_actions

WHERE (TOKEN0_SYMBOL = 'OP' or TOKEN1_SYMBOL = 'OP')

GROUP by LP_ACTION),

active_user as (

SELECT

COUNT (DISTINCT TX_HASH) as Totaltransaction

FROM optimism.core.fact_transactions

SELECT *

, (users/Totaltransaction)*100 as "Users Percentage"

FROM liquidity , active_user