Extra query 1

--Prikazati administratorima glavne informacije top10 zaposlenika koji su najvise vremena proveli na bolovanju, te im dodjeliti privatne mail adrese za laksu komunikaciju sa zaposlenicima

USE AdventureWorks2012
SELECT TOP 10 WITH TIES SUBSTRING(E.LoginID,CHARINDEX('\',E.LoginID)+1,20) 'Login', PW.PasswordSalt'Secure password',PE.EmailAddress'Email',
LOWER(P.FirstName+SUBSTRING(CONVERT(NVARCHAR,YEAR(E.BirthDate)),3,2)+'@'+LEFT(E.JobTitle,1)+SUBSTRING(E.JobTitle,CHARINDEX(' ',E.JobTitle)+1,1)+'.fit.ba') AS 'Private mail',
DATEDIFF(YEAR,E.BirthDate,E.HireDate)'Starost kada se zaposlio', DATEDIFF(YEAR,E.BirthDate,GETDATE())'Starost'
FROM [HumanResources].[Employee] AS E
JOIN [Person].[Person] AS P ON E.BusinessEntityID = P.BusinessEntityID
JOIN [Person].[Password] AS PW ON P.BusinessEntityID=PW.BusinessEntityID
JOIN [Person].[EmailAddress] AS PE ON P.BusinessEntityID=PE.BusinessEntityID
ORDER BY E.SickLeaveHours DESC