What are user segmentation techniques? How to locate your Power users? How to do user segmentation analysis in SQL?
Thanks for post. (1) I still struggle to understand why did you define power users based just on number of invited users. I can easily imagine a situation when there are some users with a lot of invites but these invitees are inactive. (2) I think you missed to add alias to Ntile() as you referencing Influencer_score but there is no such a field in the code snippet.