select -- case WHEN fee_usd > 0 and fee_usd <=10 then 'between 0 and 10 ' -- WHEN fee_usd > 11 and fee_usd <=20 then 'between 11 and 20 ' -- WHEN fee_usd > 21 and fee_usd <=30 then 'between 21 and 30 ' -- WHEN fee_usd > 31 and fee_usd <=40 then 'between 31 and 40 ' -- WHEN fee_usd > 41 and fee_usd <=50 then 'between 41 and 50 ' -- WHEN fee_usd > 51 and fee_usd <=60 then 'between 51 and 60 ' -- WHEN fee_usd > 61 and fee_usd <=70 then 'between 61 and 70 ' -- WHEN fee_usd > 71 and fee_usd <=80 then 'between 071 and 80 ' -- WHEN fee_usd > 81 and fee_usd <=90 then 'between 081 and 90 ' -- WHEN fee_usd > 91 and fee_usd <=100 then 'between 091 and 100 ' -- WHEN fee_usd > 101 and fee_usd <=110 then 'between 0101 and 110 ' -- WHEN fee_usd > 111 and fee_usd <=140 then 'between 0111 and 140 ' -- WHEN fee_usd > 141 and fee_usd <=170 then 'between 0141 and 170 ' -- WHEN fee_usd > 171 and fee_usd <=200 then 'between 0171 and 200 ' -- WHEN fee_usd > 201 and fee_usd <=250 then 'between 0201 and 250 ' -- WHEN fee_usd > 251 and fee_usd <=300 then 'between 0251 and 300 ' -- WHEN fee_usd > 301 and fee_usd <=400 then 'between 0301 and 400 ' -- WHEN fee_usd > 401 and fee_usd <=500 then 'between 0401 and 500 ' -- end as Fee_USD_range, case when ethereum.transactions.gas_price/pow(10,9) between 1 and 50 then '0001-50' when ethereum.transactions.gas_price/pow(10,9) between 51 and 100 then '0051-100' when ethereum.transactions.gas_price/pow(10,9) between 101 and 200 then '0101-200' when ethereum.transactions.gas_price/pow(10,9) between 201 and 300 then '0201-300' when ethereum.transactions.gas_price/pow(10,9) between 301 and 400 then '0301-400' when ethereum.transactions.gas_price/pow(10,9) between 401 and 500 then '0401-500' when ethereum.transactions.gas_price/pow(10,9) between 501 and 600 then '0501-600' when ethereum.transactions.gas_price/pow(10,9) between 601 and 700 then '0601-700' when ethereum.transactions.gas_price/pow(10,9) between 701 and 800 then '0701-800' when ethereum.transactions.gas_price/pow(10,9) between 801 and 900 then '0801-900' when ethereum.transactions.gas_price/pow(10,9) between 901 and 1000 then '0901-1000' when ethereum.transactions.gas_price/pow(10,9) between 1001 and pow(10,9) then '1001-ထ' end as GAS_range, count ( DISTINCT tx_id) as "number_of_transactions" from ethereum.transactions WHERE to_address = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' GROUP BY GAS_range HAVING GAS_range is NOT NULL and "number_of_transactions" is not NULL ORDER BY "number_of_transactions" DESC

7. [Hard] ENS vs Gas