180 Day Job Postings
Let’s say you work at a job board website. It is currently January 1st, 2022. You have the following table containing information about employers who have posted a job to the website.
Write a query to return the percentage of users that have either
- posted a job that is more than 180 days ago.
- posted a job with the same
job_idas a previous job posting(s), that altogether, have been on the website for more than 180 days.
Call the output’s single column