I did think about this a little. Ranking across both projects and subprojects is a little more convoluted as they are in distinct tables. But I did construct some sql for just projects or just subprojects, even discarding highest and lowest so it is doable
Code:
MariaDB [static]> select avg(projrank0) from dcfree.boinc_user where cpid = 'fa1a611d7c2bb42d13617eb6b8903f8c';
+----------------+
| avg(projrank0) |
+----------------+
| 3298.3542 |
+----------------+
1 row in set (0.02 sec)
MariaDB [static]> select (sum(projrank0) - max(projrank0) - min(projrank0)) / (count(projrank0) - 2) as average from dcfree.boinc_user where cpid = 'fa1a611d7c2bb42d13617eb6b8903f8c';
+-----------+
| average |
+-----------+
| 2479.9255 |
+-----------+
1 row in set (0.00 sec)