Practice LinkedIn SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Identify individual profiles that have higher follower counts than their associated company pages.
Filter out profiles lacking a valid employer reference since comparison requires both metrics.
Return matching profile identifiers in ascending order.

What This Tests

Table joining via foreign keys
Row-wise value comparison across tables
Conditional filtering
Result set sorting

Common Patterns

Inner Join

Sort

Test Cases

Input

-

Output

-

Expected

-