初学者SQL / Dune分析

Question

我一直在玩沙丘分析，但似乎不能让它发挥作用！

我已经设法过滤了一个钱包，以显示交易，显示出售的令牌数量和相应的BNB接收(在我开始乱搞它之前它是工作的)。

的问题，我正在加入相应的BNB价格在那一天(我认为我需要做一个内部连接函数)。

基本上，我想要四栏，日期，日期，编号。出售的滴水代币BNB收到BNB的价格(当天)

最后这部分我完全被困住了！

WITH Drip_Data AS
(SELECT
  "bnb_amount" / 1e18 AS BNB_Received_Raw,
  "token_amount" / 1e18 AS Drip_Sold,
  DATE_TRUNC('day', evt_block_time) AS day
FROM
  drip."fountain_evt_onBnbPurchase"
WHERE
  buyer = '\xFdD4D2e4e3b344429107590c20BCf4B88281Da33'
),
BNB_Data AS (
SELECT BNB_USD_PRICE FROM dune_user_generated."bnb_price" AS BNB),

谢谢!

Answer 1

你是完全正确的，因为你需要为BNB的价格数据做一个连接！在这里，我选择了左加入

WITH drip_data AS
(
SELECT
    "bnb_amount" / 1e18 AS BNB_Received_Raw
    , "token_amount" / 1e18 AS Drip_Sold
    , DATE_TRUNC('day', evt_block_time) AS time
FROM
    drip."fountain_evt_onBnbPurchase"
WHERE
    buyer = '\xFdD4D2e4e3b344429107590c20BCf4B88281Da33'
)

, bnb_data AS 
(
SELECT 
    time
    , "bnb_usd_price"
FROM dune_user_generated."bnb_price"
)

SELECT 
    d.time as "DATE"
    , d.Drip_Sold as "No. Drip Tokens Sold"
    , d.BNB_Received_Raw as "BNB Received"
    , b.bnb_usd_price as "BNB Price"
FROM drip_data d
LEFT JOIN bnb_data b
ON d.time = b.time

我也保存了这个沙丘质疑

希望这就是你要找的！