a more efficient SQL query would be directly using created >= '2018/06/01'instead of CONVERT.
How many posts were upvoted by bid bots that appeared in the trending section? (Top 100 Posts in terms of author rewards were taken from the data)
Great effort, but it would be better if you written a script instead of checking it manually.
In case u need list of bid bots, here's steemhunt repository: https://github.com/Steemhunt/api/blob/5dd78186c115c73ceebb27dfaf496304d4c9a143/db/bid_bot_ids.json
RE: Trending Page & Bid Bots - Analysis of Top 100 Posts For The Month of May, 2018