Can't see all of it yet, but you need to compare records in the table against other records, so you need a self-join. You need a primary key (eventid) to prevent a row from joining itself. The same table must be listed twice in the FROM clause, and you do the join with set of conditions to...