RE: Snaps Container // 1743183360

[shiftrox]

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'

Comments

[shiftrox]

AND [to] = 'hive_user'
AND [timestamp] >= DATEADD(day, -30, GETDATE())
and [memo] like '[e-mail]%'

[friendlymoose]

Thanks mate!

[shiftrox]

No problem! It's much easier to track the performance of your snaps now