Attached is a spreadsheet that depicts what we have in SQL and what the output needs to be based on that information. It is a very small sample, but you can see that there are several students with multiple entries and some students that have a single entry. I hope this helps explain what we are trying to accomplish. I know I can do this in Excel as I have shown, but we would prefer to be able to accomplish this in SQL if possible.