This is the 30-day Comment Reward from the snaps alone. So this is just the "reward" for engaging and attracting people's attention to my snaps.
Engagement is the best thing we can do, meeting new people and earning resources to reinvest.
Thanks @gwajnberg for the SQL.
Haha, but it helps to be able to buy more tokens or do a powerup :D
Thx my friend!
Wow about $17 USD in rewards over 30 days or about $0.57/day distributed. So cool! !BBH
Looking at the financial side of things, there's still the part about the votes that snaps can receive, but this total value of $17 just for engagement is really good, it's a nice incentive because it makes us try to do better and better to attract more people.
Isso é incrível! Um dinheiro extra com apenas o engajamento. Congrats bro!
Isso aí, agora é reinvestir e aproveitar.
Comentar, engajar, ganhar, reinvestir e repetir
this program thing is making me dizzy but looks cool! will try this one sometimes
This is dbeaver, with which we can connect to several different types of database, such as postgresql, mysqlserver, mysql, oracle and so on. As I have access to hivesql, I sometimes make some queries to see performance or metrics.
Exatamente, lembrando que nem é só pelo "dinheiro" as conexões e interações que fazemos aqui podem trazer bons frutos no futuro também.
Cool! Could you copy the SQL script in text? I have access to HiveSQL too :)
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%'
