Top 30 Writer Listings In SLOTHICORN Based on Pending Payout Value
slothicorn·@irwanumpal·
0.000 HBDTop 30 Writer Listings In SLOTHICORN Based on Pending Payout Value
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 @arcange. this article I also appreciate to @paulag who has written in the field of analysis and teach many things to many people in online course site that you can see here https://www.udemy.com/ 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.    <H2>CONCLUSION</H2> 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. <H2>TOOLS</H2> 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. <pre><code>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</code></pre> <center><h2>**My Best REGARD @irwanumpal**</h2></center>  <center></center>[download](http://gdurl.com/6oY4/download)