将各个事件的表格 - 距离转换为事件汇总表

Two weeks ago I started learning SQL and it has been going pretty good so far but I have run into a situation that I can't seem to resolve. After two days of searching the web and looking at books, I am no closer to solving this issue, so time to ask for some help. Part of my problem is that being so new to SQL I'm not exactly sure what to search for.Two weeks ago I started learning SQL and it has