By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Name | Category | totaltime | s1time | s2time | s3time | s4time |
---|---|---|---|---|---|---|
Bob | Beginner | 4000 | 1000 | 1000 | 1000 | 1000 |
Charlie | Beginner | 4400 | 1100 | 1100 | 1100 | 1100 |
Jack | Beginner | 4500 | 1125 | 1075 | 1150 | 1150 |
Megan | Beginner | 4400 | 1100 | 1100 | 1100 | 1100 |
Paul | Beginner | 4500 | 1125 | 1075 | 1150 | 1150 |
Alice | Intermediate | 4400 | 1100 | 1100 | 1100 | 1100 |
Mike | Intermediate | 4400 | 1100 | 1100 | 1100 | 1100 |
Sally | Intermediate | 4400 | 900 | 1200 | 1300 | 1100 |
Fred | Pro | 4400 | 1100 | 1100 | 1100 | 1100 |
John | Pro | 4400 | 1100 | 1100 | 1100 | 1100 |
Category | total | s1 | s2 | s3 | s4 |
---|---|---|---|---|---|
Beginner | Bob | Bob | Bob | Bob | Bob |
Intermediate | Sally,Alice,Mike | Sally | Alice,Mike | Alice,Mike | Alice,Mike |
Pro | John,Fred | John,Fred | John,Fred | John,Fred | John,Fred |