表如下
| job_id | member_id | job_posting_date |
|---|---|---|
| 1001 | 1 | 2017-04-14 |
| 1002 | 1 | 2017-08-14 |
| 1003 | 2 | 2017-05-31 |
| 1004 | 3 | 2016-08-23 |
| 1005 | 3 | 2017-04-28 |
| 1006 | 3 | 2017-05-23 |
| 1007 | 3 | 2017-07-08 |
New Job Posting: job posting by a member who’s never posted a job on linkedin platform before
Repeat Job Posting: job posting by a member who’s ever posted a job on LinkedIn platform before
Q1:
How many new job posting and how many repeat job posting from a given table?
Q2:
Let’s introduce a new concept reactivation job posting, which refers to job posting by a member who’s ever posted a job but not in the previous 180 days