Power Creators (Part 1) — SQL Question Asked By LinkedIn

Solving SQL Question asked by LinkedIn

Suraj Mishra

·

Follow

3 min read

·

Sep 30, 2022

--

Share

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.