Vjezbe sql

USE AdventureWorks2012
SELECT PP.FirstName+' '+ PP.LastName AS 'Ime i Prezime',
SUBSTRING(HE.LoginID,CHARINDEX('\',LoginID)+1,30)'Korisnicko ime',
LEFT(SUBSTRING(REVERSE(PPW.PasswordHash),5,8),1) +'X#'+ SUBSTRING(SUBSTRING(REVERSE(PPW.PasswordHash),5,8),5,7)  AS 'Lozinka',
DATEDIFF(YEAR,HE.BirthDate,GETDATE())'Starost',
DATEDIFF(YEAR,HE.HireDate,GETDATE())'Staz'
FROM HumanResources.Employee AS HE JOIN Person.Person AS PP ON HE.BusinessEntityID=PP.BusinessEntityID JOIN Person.Password AS PPW ON PP.BusinessEntityID=PPW.BusinessEntityID
WHERE HE.Gender LIKE 'F' AND DATEDIFF(YEAR,HE.BirthDate,GETDATE())>50 AND DATEDIFF(YEAR,HE.HireDate,GETDATE())>10