Power Creators (Part 1) — SQL Question Asked By LinkedIn
Solving SQL Question asked by LinkedIn
3 min readSep 30, 2022
Originally Published in https://asyncq.com/
Introduction
- In this article we will solve Power Creators (Part 1) SQL question which is asked by LinkedIn as per DataLemur website.
If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.
Question
- We have been given personal_profile pages and company pages.
- If someone’s personal profile has more followers than company they work for then they are power creators.
- We need to return the ID’s of such power creator.
- As we can see below profile_id has personal followers more than company followers.
