-- forked from 15897ffa-4563-4c7a-9f08-65bb74c3fd43
-- forked from b89f5e3b-87eb-401c-b6e8-d08a5d86bd76
-- forked from 51bddb57-5c2f-428b-b616-053e49317804
WITH Table1 AS (
SELECT
PURCHASER,
SUM(SALES_AMOUNT) AS PURCHASER_Vol_SOL
FROM
solana.core.fact_nft_sales
WHERE
MARKETPLACE = 'tensorswap'
AND
BLOCK_TIMESTAMP >= '2023-03-06'
GROUP BY
1
ORDER BY
2 DESC
),
Table2 AS (
SELECT
SELLER,
SUM(SALES_AMOUNT) AS SELLER_Vol_SOL
FROM
solana.core.fact_nft_sales
WHERE
MARKETPLACE = 'tensorswap'
AND
BLOCK_TIMESTAMP >= '2023-03-06'
GROUP BY
1