So, couple of days ago, some guy, from Periscope company wrote a blogpost about getting number of distinct elements, per group, faster using subqueries. This was then submitted to Hacker News and r/Programming on Reddit. Then, the original authors submitted second blogpost ...