Hello,
nine days ago I wrote the post Bad News: New Steemians Are Left Alone.
I listed a set of people that are new on Steemit and I showed, that only about 20% of them are active now.
I suggested to all promotors to tell the newbies to set their location country, so that I'm able to find them on the SteemSQL-database.
So here are my new statistics and my please to care about the listet people below:
And here are the beginners in steemit from April and May 2018. Please click at them and upvote their posts:
select year(a.created) as year, month(a.created) as 'Month', a.name
from Accounts a
where a.json_metadata like '%uganda%'
order by year(a.created), month(a.created)
If there are other newbies from Uganda you know about (then they have not set the location-field='Uganda'), please add them in the comments.
Here one can see how busy they are:
select author, count (author) as 'count of posts'
from comments
where author in
(Select name
from accounts
where json_metadata like '%uganda%'
and (month(created)='4' or month(created)='5')
and year(created)='2018'
)
group by author
order by author
| User | Number Of Comments (Posts or Replies) |
|---|---|
 | 51 |
 | 15 |
 | 1 |
 | 35 |
 | 17 |
 | 58 |
 | 1 |
 | 188 |
 | 3 |
 | 8 |
 | 8 |
 | 2 |
 | 4 |
 | 4 |
 | 2 |
 | 56 |
 | 1 |
 | 3 |
 | 4 |
 | 24 |
 | 21 |
 | 41 |
 | 12 |
Regards, Achim