Trying to get: The top-20 PIs who have the largest total amount of awards along with the universities they are affliated with.
Mysql: SELECT award, pi, org FROM tbl WHERE groupby(award) LIMIT 20
Table:
It seems to not like my group by. Whats going wrong here?
See Question&Answers more detail:os