SELECT PROJECT_NAME, SUM(TOTAL_PRICE_USD) AS TotalSalesUSD

FROM nft_sales

GROUP BY PROJECT_NAME

),

TransfersSum AS (

SELECT PROJECT_NAME, SUM(TOTAL_PRICE_USD) AS TotalTransfersUSD

FROM nft_transfers

GROUP BY PROJECT_NAME

SELECT S.PROJECT_NAME, S.TotalSalesUSD, T.TotalTransfersUSD

FROM SalesSum S

JOIN TransfersSum T ON S.PROJECT_NAME = T.PROJECT_NAME;