Problem

Create a query that will show the person id and the number of months a

coach has been in service. Only include those coaches who have left the

league. Do not include those coaches that are still coaching. Include the

following column headings: PersonID, Months of Service. Finally sort you

result set by the Months of Service column so that the coach with the

highest number of months shows first.

Your output should look like the table below.