You are viewing a single comment's thread from:
RE: Basic Analysis on the Top 10 DApps on Steemit – Activity and Support to the Community
nice work. a quick tip on the query, it looks like you may have run this app by app. In the queries you could change [voter] in ('partiko')to [voter] in ('partiko', 'actifit', 'dtube'....) and include all the apps in the same query.
You will also see in the query I have hard coded the value of a vote, I took this value from steemworld.org and it changes often and is different for each app
Delighted to see the use of Excel more and more for analysis, if you get stuck or need a hand let me know
Also hoping you will consider @steemcommunity as one of your steem witnesses, its a witness project ran by myself and @abh12345
Thank you very much @paulag for your sincere support.
Yes I have run the query for each app. Your tip is very much welcomed.
I have notice the value of the vote, and adjusted it in the table.
You have my suport on @steemcommunity for witness :)
yeppeee thanks for your support. SQL is not my strong point, but I will help out where I can. Running all these queries one after another must have been rather time consuming.
The price of inexperience :)
But it was a good practice.
when I started I did many many things the long way, as you get a feel for the database and the queries, it will get easier :-)