I have a view where multiple JOB PROGRESS ID is attached to 1 JOB_ID. So if there are 2 JOB PROGRESS ID there are 2 status_id. SO I want to get the latest status id based on job porgress id desc. Below is the view.