如何使用SQL查询基于顺序关系选择记录

I am trying to query some information from certain large data on connections among a set of clients and servers. Below are sample data from relevant columns in the table (connection_stats):I am trying to query some information from cert