SQL Query：如何只返回第一个和最后一个实例？

I have a table that shows the status of each case with multiple jobs being performed simultaneously, I would like to have the results displayed so that it only shows the first and last instance. (Mainly I want to know when the job was first started and what's its last known status). I have a table that shows the status of each ca