Cool! Could you copy the SQL script in text? I have access to HiveSQL too :)
You are viewing a single comment's thread from:
Sort: Trending
I'll have to break into 2 snaps here to go:
select sum(case when [amount_symbol] = 'HIVE' THEN [amount] ELSE 0 END) AS HiveTotal,
sum(case when [amount_symbol] = 'HBD' THEN [amount] ELSE 0 END) AS HBDTotal
FROM [TxTransfers]
WHERE [from] = 'commentrewarder'
AND [to] = 'hive_user'
AND [timestamp] >= DATEADD(day, -30, GETDATE())
and [memo] like '%%@peak.snaps%'
