Are such calculations implemented by the built-in capabilities of Access?

Question

SQL

I'm doing a coursework on the database, the deadlines are burning, but I really didn't figure it out. Here is one of the questions:
Let's say we have a table with fields: Song_name, Artist, Number of_awards (for a song) and we need to find the top 10 performers by the number of awards.
Poking around in MS Access, I did not find anything suitable. Need to do it via SQL?
Of course, I found how to do a sample sum, like SELECT SUM ([Number_of_awards]) FROM Songs WHEREArtist = 'Ivanov' and so on for each artist, and sort the results. But I don't know how to implement it. So far, from ideas, only write a third-party program, but in my opinion this is a crutch. Time to fully read the textbooks on SQL and Access, so I'm asking for tips on how to do such calculations easier and faster.
PS In Excel, I would do it without problems, but you can't use it.

Answer 1

SELECT TOP (10) Исполнитель, SUM(Количество_наград) AS Награды
FROM [таблица с полями]
GROUP BY Исполнитель
ORDER BY Награды DESC