Top 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.

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

My Best REGARD @irwanumpal

download