php - Count the rows of the 'author' which is listed in the database at most -

i want following thing:

in mysql table have column called 'author'. rows of column contain names of authors. find out name listed @ in column , count how many times.

i afraid can't provide codes, since don't know how build query yet.

select author, count(*) countauthors books group author order countauthors desc limit 1