SteemSQL 教程 - 我花了800多 SBD (7000多美元)买赞

money-calculator-potato

不查不知道, 一查吓一跳, 我前前后后花了大概800多 SBD买赞! 按市价就是7000多美元! 天啊撸. 查询如下:

select "from", "to", "memo", (amount)
from TxTransfers (NOLOCK)
where
    "from" = 'justyy' and
    memo like 'http%'

select "from", "to", "memo", (amount)
from TxTransfers (NOLOCK)
where
    "from" = 'justyy' and
    memo like 'http%'

这个语句显示了所有买赞的记录, 我们再细分一下, 按 “to” 来分组:

select "to", sum(amount)
from TxTransfers (NOLOCK)
where
    "from" = 'justyy' and
    memo like 'http%'
group by
    "to"

select "to", sum(amount)
from TxTransfers (NOLOCK)
where
    "from" = 'justyy' and
    memo like 'http%'
group by
    "to"

这下更清楚了:

txtransfers-buying-upvotes

除去之前搞活动给 @oflyhigh , @travelgril, @wilkinshui 还有 @yuxi 的几笔小额奖励不算, 真的花了7000多美元买赞! 特别是之前很大一段时间都在给 @minnowbooster 买赞, 一共花了 686.7 SBD.

STEEMIT 为啥要买赞?

我的原因有:

所以即使从帐面上看, 买赞并不划算, 但是考虑到以上三点, 也不那么纠结了.

GD Star Rating
loading...

本文一共 412 个汉字, 你数一下对不对.

扫描二维码，分享本文到微信朋友圈