SteemSQL Tutorial: What is Your Monthly Income on Steemit?

MSSQL Database

Have you wondered that the your earnings on STEEMIT can really make a difference? Have you thought about making a living by full time blogging on steemit? The easiest way is to look at your historic earning data monthly so you get a rough idea via the following SQL.

1
2
3
4
5
6
7
8
9
10

select 
    FORMAT(created, 'yyyy-MM') Month, sum(total_payout_value) Min,  sum(total_payout_value) + sum(curator_payout_value) Max
from 
    Comments (NOLOCK)
where
    author='justyy'
group by
    FORMAT(created, 'yyyy-MM')
order by
    FORMAT(created, 'yyyy-MM') desc

select 
    FORMAT(created, 'yyyy-MM') Month, sum(total_payout_value) Min,  sum(total_payout_value) + sum(curator_payout_value) Max
from 
    Comments (NOLOCK)
where
    author='justyy'
group by
    FORMAT(created, 'yyyy-MM')
order by
    FORMAT(created, 'yyyy-MM') desc

We know that 75% are author rewards, so if we group the data by months, sum the author rewards, that will be the minimal level of payout. Suppose you get all other 25% curation rewards e.g. always upvotes at 30 min, that is the maximum (in theory) you earn.

In my case, here is my earning data per calendar month, I have no idea why the Sept (this month) is zero earnings (maybe data is not synchronized into steemSQL from the blockchain yet?)

monthly-steemit-payout-earnings

It would be great if you could share yours in the comments (the data is public anyway). In 7 days, I will give 1 SBD to whoever has the lowest and highest payout respectively (in August 2017).

You may also like: STEEM SQL 系列之 每个月到底能挣多少？

STEEM SQL Tutorial

• SteemSQL Tutorial: How to Get Random Posts on SteemIt?
• SteemSQL Tutorial: How to Get Authors Order By Potential Payout in Last 7 days?
• SteemSQL Tutorial: How to Get Historic Posts of Today on SteemIt?
• SteemSQL Tutorial: How to Calculate Monthly Income on STEEMIT?
• SteemSQL Tutorial: Can we Really Recover Deleted Comments/Posts on STEEMIT?
• SteemSQL Tutorial: What are the Outgoing Votes for Big Whales?
• SteemSQL Tutorial: Count Total Interests Sent
• SteemSQL Tutorial: Finding Inactive Steemians that You Follow
• SteemSQL Tutorial: How to Fix “JSON text is not properly formated. Unexpected character ‘.’ is found at position 0.”?
• SteemSQL Tutorial: How to Get the Most Payout Authors in History?
• SteemSQL Tutorial: Get Most Single Payout Authors
• SteemSQL Tutorial: How to Avoid SQL Injection?
• SteemSQL Tutorial: I have spent 800 SBD (7000+ USD) buying votes!
• SteemSQL Tutorial: How to Check If SteemSQL is Synchronized with Steem Blockchain?

–EOF (The Ultimate Computing & Technology Blog) —