SQL Server——当以前的日期不是空的时候获得最高的值

I have a table that contains information for player's steps taken for any given day, I want to get the 3 highest totals from the database, when the day before the day of the high total has a value added to it for that player. Since some players are not logging everyday, but rather lumping multiple days into one update.I have a table that contains information for pl