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 TJob_Posting_Date 100 9XZZZZ 1/1/17! 100|7YERT7 2/1/17 L____101 8y2vvel_-_-_-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_postnum_of_days_from_last_post 100 9XZZZZ 1/1/17|Y <NULL 100|7YERT7 2/1/17 N 101 82vval 5/8/18 Y |<NULL 31 Show transcribed image text 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 TJob_Posting_Date 100 9XZZZZ 1/1/17! 100|7YERT7 2/1/17 L____101 8y2vvel_-_-_-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_postnum_of_days_from_last_post 100 9XZZZZ 1/1/17|Y
Expert Answer
Answer to Question 3 Consider we own a Job site where members can job post. Whenever a job is posted by a member entry created as …