Practice SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Identify companies posting identical job titles and descriptions multiple times
Group data by company and job details to isolate repeated entries
Return the total count of unique companies with such duplicates

What This Tests

Multi-column grouping logic
Filtering aggregated groups based on row counts
Counting distinct entities from a filtered dataset

Common Patterns

Aggregation

HAVING Filter

Groupby

Accepted

12/26

Acceptance Rate46.2%

Test Cases

Input

-

Output

-

Expected

-