Query editor
WITH OperatorAllowed AS (SELECTblock_time,JSON_EXTRACT_SCALAR(data, '$[0]') AS op,'Allowed' AS methodFROM energywebx.eventsWHEREmethod = 'NewOperatorAllowed'UNION ALLSELECTblock_time,JSON_EXTRACT_SCALAR(data, '$[0]') AS op,'Disallowed' AS methodFROM energywebx.eventsWHEREmethod = 'OperatorDisallowed'), list AS (SELECTblock_time,op,method,ROW_NUMBER() OVER (PARTITION BY op ORDER BY block_time DESC) AS rnFROM OperatorAllowed), nameloc AS (SELECTJSON_EXTRACT_SCALAR(data, '$[0]') AS op,FROM_UTF8(FROM_HEX(JSON_EXTRACT_SCALAR(data, '$[1]'))) AS name,FROM_UTF8(FROM_HEX(JSON_EXTRACT_SCALAR(data, '$[2]'))) AS locationFROM energywebx.eventsWHEREmethod = 'NewWorkerNodeOperatorSignup'), AVT AS (SELECTJSON_VALUE(e.data, 'strict $[0]') AS account,TRY_CAST(JSON_VALUE(e.data, 'strict $[1]') AS uint256) / POW(10, 18) AS amount,methodFROMenergywebx.events eWHEREmethod IN ('AVTLifted', 'AVTLowered'))SELECTGET_HREF(CONCAT(CAST('https://energywebx.subscan.io/account/' AS VARCHAR),CAST(TRY_CAST(rewards.workernode AS VARCHAR) AS VARCHAR)),CONCAT(CAST(SUBSTR(rewards.workernode, 1, 4) AS VARCHAR),CAST('...' AS VARCHAR),CAST(SUBSTR(rewards.workernode, LENGTH(rewards.workernode) - 4 + 1) AS VARCHAR))) AS Operator,nameloc.name,nameloc.location,-- Total Lifted column (5th column) with SUM first, then FORMAT_NUMBERFORMAT_NUMBER(CAST(COALESCE(SUM(CASE WHEN avt.method = 'AVTLifted' THEN avt.amount ELSE 0 END), 0) AS DOUBLE)) AS total_lifted,rewards.amount AS rewards_collected,rewards.rank AS rewards_rank,stats.first_seen,