Question 3
Consider we own a Job site where members can job post. Whenever a job is posted by a member entry
created as below,
Member_ID Job_ID Job_Posting_Date
100 9XZZZZ 1/1/17!
100 7YERT7 2/1/171
101 8Y2VVQ 5/8/18
Write a sql to derive below additional columns, (Note: For First job, num_of_days_from_last_post is
NULL)
Member_ID Job_ID Job_Posting_Date is_first_job_post num_of_days_from_last_post
100 9XZZZZ 1/1/17 Y <NULL>
100 7YERT7 2/1/17 N 31
101 8Y2VVQ 5/8/18 Y <NULL>