How to display only 10 entries by the amount of power bi costs?

Question

Electronic accounting

The figure shows a report on data from the category, provider, and cost tables. How to display only 10 providers at the maximum cost?

Answer 1

For T-SQL, I think TOP 10.
With the use of GROUP BYand ORDER BY.