select BLOCK_TIMESTAMP::date as "Day",tx_hash ,ORIGIN_FROM_ADDRESS as "Swapper",'Arbitrum' as "Layer Name" from arbitrum.sushi.ez_swaps where block_timestamp >= '2022-05-01'

),

op_swapper as (

select BLOCK_TIMESTAMP::date as "Day",tx_hash ,ORIGIN_FROM_ADDRESS as "Swapper",'Optimism' as "Layer Name" from optimism.sushi.ez_swaps where block_timestamp >= '2022-05-01'

),

poly_swapper as (

select BLOCK_TIMESTAMP::date as "Day",tx_hash ,ORIGIN_FROM_ADDRESS as "Swapper",'Polygon' as "Layer Name" from polygon.sushi.ez_swaps where block_timestamp >= '2022-05-01'

), all_uni_swaps as (

select * from arbi_swapper

union all

select * from op_swapper

union all

select * from poly_swapper

),total_info as (

select

count(DISTINCT tx_hash) as "Total Number of Swaps",

count( DISTINCT "Swapper") as "Number of Unique Swapper"

from all_uni_swaps

),total_poly_info as (

select

count(DISTINCT tx_hash) as "Total Number Polygon of Swaps",

count( DISTINCT "Swapper") as "Number of Polygon Unique Swapper"

from poly_swapper

),total_op_info as (

select

count(DISTINCT tx_hash) as "Total Number Optimism of Swaps",

count( DISTINCT "Swapper") as "Number of Optimism Unique Swapper"

from op_swapper

),total_arbi_info as (

select

count(DISTINCT tx_hash) as "Total Number Arbitrum of Swaps",

count( DISTINCT "Swapper") as "Number of Arbitrum Unique Swapper"

from arbi_swapper

),just_poly_unique_user as (

select count( DISTINCT "Swapper") as "Users Just Use Uni In Polygon" from ( select "Swapper" from poly_swapper except ( select "Swapper" from op_swapper union select "Swapper" from arbi_swapper))