LinkedIn Easy Group By Ranking

Most Active
Hiring
Company

Find the company that posted the highest number of job listings.

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.
company_name	string	Name of the company posting the job.
title	string	Job listing title.
location	string	Job location.
posted_date	date	Date the job was posted.
salary	integer	Listed salary.

Sample Data

Sample Input: job_listings

job_id	company_id	company_name	title	location	posted_date	salary
101	1	ABC Corp	Data Analyst	NY	2024-01-01	70000
102	1	ABC Corp	Data Scientist	SF	2024-01-05	120000
103	2	XYZ Inc	Data Analyst	TX	2024-01-03	80000
104	1	ABC Corp	ML Engineer	NY	2024-01-10	130000
105	3	TechSoft	Analyst	CA	2024-01-02	60000
106	2	XYZ Inc	Engineer	TX	2024-01-07	90000

Expected Output

company_id	job_count
1	3

SQL Editor

Waiting for query

company_id	job_count
1	3

Hints

Hint 01: Group rows by company_id so every company has one group.

Hint 02: Use COUNT(*) AS job_count to count how many listings each company posted.

Hint 03: Order by job_count DESC and LIMIT 1 to return the top company.

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,
  COUNT(*) AS job_count
FROM job_listings
GROUP BY company_id
ORDER BY job_count DESC
LIMIT 1;

Explanation

Group rows by company_id so each company becomes one output group.

Use COUNT(*) to calculate how many job listings each company posted.

Sort by job_count descending and use LIMIT 1 to keep the most active hiring company.