Data query, showing the top few with the same value in a column

fiywing

I want to find the date in a table that is within the limit, and then the value of the other column appears the most, and I don't know how to achieve it?
The table is for posting. I want to find the first few authors who posted the most on a specific date. How do I write it? I have written a good time, please master, thank you !!!

xcc282828

select author, count (*) as cou from table where betwenn start date and end date group by author

獠牙精英

SELECT *
FROM
WHERE
BETWEEN
GROUP BY