如何限制每个特定结果组的SQLite结果？

I have the following problem at work. I have a large table with different columns and few 100 000s of rows. I'll only post the ones im interested in.I have the following problem at work. I have a