In the third study of statistics 2018 for my post, I will look at the numbers for taging slothicorn. Taging slothicorn is one of the taging on the steemit platform that has a lot of art-related content and crypto art.
on this occasion I want to display the figures I get by using steem blockchain database from Steem Sql developed by 
the following I will show the data in table that I get through the database blockchain in Steem sql.
LIST OF 30 AUTHORS IN SLOTHICORN TAG DURING THE LAST 30 DAYS
| author | post | votes | pending payout value |
|---|---|---|---|
| stellabelle | 2 | 429 | 103,45 |
| daltono | 6 | 122 | 79,25 |
| kalemandra | 3 | 113 | 60,188 |
| alexandravart | 12 | 463 | 50,021 |
| mimulusamsterdam | 2 | 32 | 29,172 |
| slothicorn | 6 | 368 | 27,232 |
| ivanusaur | 4 | 108 | 26,932 |
| federacion45 | 16 | 206 | 23,303 |
| bym | 15 | 168 | 21,628 |
| jnmarteau | 17 | 282 | 21,626 |
| drawingly | 18 | 597 | 20,419 |
| fabiyamada | 9 | 281 | 20,299 |
| trishy | 7 | 168 | 17,925 |
| ediah | 9 | 251 | 17,119 |
| inksanity | 3 | 19 | 17,051 |
| jepoyasinas | 10 | 226 | 14,526 |
| khansa | 13 | 181 | 14,228 |
| matytan | 19 | 280 | 12,606 |
| richforever | 1 | 24 | 11,844 |
| iqbalhood | 5 | 127 | 11,772 |
| trangpu | 6 | 45 | 11,567 |
| anonimous | 1 | 16 | 11,377 |
| cryptocomic | 4 | 60 | 11,203 |
| marpa | 13 | 527 | 10,622 |
| debart | 21 | 259 | 8,973 |
| mfestra | 2 | 35 | 8,724 |
| photoquest | 6 | 43 | 8,54 |
| rayne122 | 2 | 110 | 8,077 |
| bryanlornemez | 3 | 94 | 7,931 |
| journeyu | 5 | 73 | 7,661 |
| summary | 240 | 5707 | 695,266 |
Based on the above data we can see the composition of the number of post, vote and payment deferred for each of the top 30 authors in the past month.
and we can also see it in the chart that I created with excel as a description of the data above based on the percentage value of each author for each category.
CONCLUSION
of the many posts that go to tagging slothicorn we can see the top 30 writers based on the value of pending payments. in the above data we can also see the number of posts by the top 30 authors as much as 240 posts and get vote number 5707 and overall payment for the top 30 of 695,266 SBD. the average payment for post in the slothicorn tag is 2.89 SBD based on the data of the top 30 authors.
TOOLS
This data is retrieved through the steemsql database using lynqpad personal edition at 03.30am on 03.30.20 at 23:17 (UTC + 07: 00) Bangkok, Hanoi, Jakarta. data processing is done using Microsoft Excel.
select top 30
author,
count(author) as cnt,
sum(net_votes) as votes,
sum(pending_payout_value) as pending_payout_value
from
Comments
where
title '' and
dirty = 'False' and
category = 'slothicorn' and
parent_author = '' and datediff(day, created, GETDATE() between 0 and 30
group by
author
order by
pending_payout_value desc