How to find out which employee has the fewest records with one query?

Question

SQL

Hello, there is a "requests" table, it stores user requests. Each request is assigned a moderator, in the moderator_id field. The goal is to get the id of the moderator with the least number of entries. To do that I did it, but not with one request. Actually, the question is - how can you get this information in one request.

Answer 1

Learn in aggregate functions. Sum, group by