SQL · LinkedIn · Easy
Table: personal_profiles > Table: company_pages > profile_id uniquely identifies each row in personal_profiles, and company_id uniquely identifies each row in company_pages. The employer_id column points to company_id in company_pages; it can be NULL when a member is self-employed or unemployed. Write a query that returns every LinkedIn member whose personal profile has a follower count greater than that of the company page associated with their employer. Return the matching…
Checking your access…