```sql
SELECT
*
FROM
A0001 a
WHERE
5 > (
SELECT
count(*)
FROM
A0001
WHERE
class = a.class
AND score > a.score)
```sql
SELECT
*
FROM
A0001 a
WHERE
5 > (
SELECT
count(*)
FROM
A0001
WHERE
class = a.class
AND score > a.score)
就是A0001表里面的score字段(分数那一列)和class字段(班级那一列)