Find amounts of top three orders in terms of amount per month in the current year:

SQL

WITH m AS(
    SELECT year(OrderDate) years, month(OrderDate) months, Amount,
        rank() OVER(PARTITION BY year(OrderDate),month(OrderDate) 
        ORDER BY Amount DESC) r 
    FROM Orders 
    WHERE OrderDate>='2022-01-01')
SELECT * 
FROM m 
WHERE r<=3  

SPL

A3 top(3,-Amount) gets Amount values of top three order records with the largest amounts. The comma-separated parameters enable getting values, while semicolon-separated ones get records (as in the next example).