LinkedIn Easy Group By Distinct

Multi Role
Hiring
Firms

Find companies hiring for more than 3 distinct job titles.

Table Schema

Inspect
Table

interactive

Column	Type	Description
job_id	integer	Unique job posting identifier.
company_id	integer	Identifier for the company posting the job.
title	string	Job listing title.
department	string	Department for the role.
location	string	Job location.
salary	integer	Listed salary.
posted_date	date	Date the job was posted.

Sample Data

Sample Input: job_listings

job_id	company_id	title	department	location	salary	posted_date
1	1	Analyst	Data	NY	60000	2024-01-01
2	1	Engineer	Eng	NY	90000	2024-01-02
3	1	Scientist	Data	SF	120000	2024-01-03
4	1	Manager	Ops	SF	110000	2024-01-04
5	2	Analyst	Data	TX	70000	2024-01-05
6	2	Engineer	Eng	TX	95000	2024-01-06

Expected Output

company_id
1

SQL Editor

Waiting for query

company_id
1

Hints

Hint 01: Group by company_id so each company gets one row.

Hint 02: Use COUNT(DISTINCT title) to count unique roles.

Hint 03: Use HAVING COUNT(DISTINCT title) > 3.

Solution

Solution is locked until you decide to reveal it. Try the editor first, then open this when you want the reference answer.

SELECT
  company_id
FROM job_listings
GROUP BY company_id
HAVING COUNT(DISTINCT title) > 3;

Explanation

Group job listings by company_id.

Count each company's distinct job titles.

Keep only companies where that count is greater than 3.