LinkedIn Easy Order By Limit

Most Common
Job
Title

Find the most frequently occurring job title.

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.
location	string	Job location.
salary	integer	Listed salary.
posted_date	date	Date the job was posted.
employment_type	string	Type of employment.

Sample Data

Sample Input: job_listings

job_id	company_id	title	location	salary	posted_date	employment_type
1	1	Analyst	NY	60000	2024-01-01	Full-time
2	2	Analyst	SF	70000	2024-01-02	Full-time
3	3	Engineer	TX	90000	2024-01-03	Contract
4	4	Analyst	CA	80000	2024-01-04	Full-time
5	5	Manager	NY	100000	2024-01-05	Full-time
6	6	Analyst	TX	65000	2024-01-06	Contract

Expected Output

title	count
Analyst
4

SQL Editor

Waiting for query

title	count
Analyst
4

Hints

Hint 01: Group by title.

Hint 02: Use COUNT(*) AS count.

Hint 03: Order by count DESC and LIMIT 1.

Solution

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

SELECT
  title,
  COUNT(*) AS count
FROM job_listings
GROUP BY title
ORDER BY count DESC
LIMIT 1;

Explanation

Group the table by title.

Count how many rows each title has.

Sort descending and keep the first row.