Getting Top 20 mysql Query Error

Question

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?

Answer 1

You need to group something, heres what your trying to do:

SELECT distinct award, pi, org FROM tbl LIMIT 20;