Practice Interview Questions
| Question | Status |
|---|---|
Write a SQL query to find the number of companies that have posted duplicate job listings. Duplicate job listings refer to two jobs at the same company with the same title and description.
job_listings table:
| Column Name | Description |
|---|---|
| job_id | Unique identifier for the job listing |
| company_id | Company ID posting the job |
| title | Title of the job listing |
| description | Description of the job listing |
Write a SQL query to find the number of companies that have posted duplicate job listings. Duplicate job listings refer to two jobs at the same company with the same title and description.
job_listings table:
| Column Name | Description |
|---|---|
| job_id | Unique identifier for the job listing |
| company_id | Company ID posting the job |
| title | Title of the job listing |
| description | Description of the job listing |
| 3 |
| 3 |