afafasfasf

USE     [AdventureWorks2014]
SELECT  P.FirstName + ' ' + P.LastName AS ImePrezime,
        E.JobTitle AS Posao,
        CONVERT(nvarchar(10), HireDate, 103) AS DatumZaposlenja,
        ROUND(SUM(TotalDue),2) AS Zarada
FROM    [HumanResources].[Employee] AS E                JOIN        [Person].[Person] AS P
        ON E.BusinessEntityID = P.BusinessEntityID      JOIN        [Person].[EmailAddress] AS PEA
        ON P.BusinessEntityID = PEA.BusinessEntityID    JOIN    [Sales].[SalesPerson] AS SSP
        ON P.BusinessEntityID = SSP.BusinessEntityID    JOIN    [Sales].[SalesOrderHeader] AS SOH
        ON SSP.BusinessEntityID = SOH.SalesPersonID     JOIN    [Sales].[SalesTerritory] AS ST
        ON SOH.TerritoryID = ST.TerritoryID

WHERE    ST.[Group] = 'Europe' AND YEAR(SOH.OrderDate) = 2014
GROUP BY    P.FirstName + ' ' + P.LastName,
            E.JobTitle,
            E.HireDate
ORDER BY 3 DESC



---- backup

BACKUP DATABASE testic
TO DISK = 'E:\DBMS\testic.bak'