SELECT CONCAT(p.FirstName, ' ', p.MiddleName, ' ', p.LastName) AS "Klient", YEAR(soh.OrderDate) AS "Rok", SUM(soh.SubTotal) AS "Kwota"
FROM AdventureWorks2017.Sales.SalesOrderHeader AS soh LEFT JOIN AdventureWorks2017.Sales.Customer AS c ON soh.CustomerID=c.CustomerID LEFT JOIN AdventureWorks2017.Person.Person AS p ON c.PersonID=p.BusinessEntityID
GROUP BY GROUPING SETS((CONCAT(p.FirstName, ' ', p.MiddleName, ' ', p.LastName), YEAR(soh.OrderDate)), CONCAT(p.FirstName, ' ', p.MiddleName, ' ', p.LastName), ());