Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Assume you are given the job_listings table that shows job postings for all companies on the LinkedIn platform. 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.
You will need to use only 1 query for that (no subquery allowed). If you don't know what this means, even better, no need to worry!
job_listings table:
| Column Name | Data Type |
|---|---|
| job_id | int |
| company_id | int |
| title | varchar |
| description | varchar |
Assume you are given the job_listings table that shows job postings for all companies on the LinkedIn platform. 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.
You will need to use only 1 query for that (no subquery allowed). If you don't know what this means, even better, no need to worry!
job_listings table:
| Column Name | Data Type |
|---|---|
| job_id | int |
| company_id | int |
| title | varchar |
| description | varchar |
| nb_duplicate_jobs |
|---|
| 5 |
| nb_duplicate_jobs |
|---|
| 5 |