--1
select (FirstName + ' ' + LastName) Klient, Year(OrderDate) Rok,  SUM(SubTotal) Kwota
from Sales.SalesOrderHeader SOH
join Sales.Customer C on SOH.CustomerID = C.CustomerID
join Person.Person P  on P.BusinessEntityID = C.CustomerID
group by rollup ((FirstName + ' ' + LastName), Year(OrderDate))


select (FirstName + ' ' + LastName) Klient, Year(OrderDate) Rok,  SUM(TotalDue) Kwota
from Sales.SalesOrderHeader SOH
join Sales.Customer C on SOH.CustomerID = C.CustomerID
join Person.Person P  on P.BusinessEntityID = C.CustomerID
group by cube ((FirstName + ' ' + LastName), Year(OrderDate))

select (FirstName + ' ' + LastName) Klient, Year(OrderDate) Rok,  SUM(TotalDue) Kwota
from Sales.SalesOrderHeader SOH
join Sales.Customer C on SOH.CustomerID = C.CustomerID
join Person.Person P  on P.BusinessEntityID = C.CustomerID
group by grouping sets (((FirstName + ' ' + LastName), Year(OrderDate)), (FirstName + ' ' + LastName), Year(OrderDate), ())