View difference between Paste ID: 7RmgLRwy and 4eG2p3KL

 --Prikazati kupce koji su potrosili preko 1000km
 USE Northwind
 SELECT C.ContactName'Ime', COUNT(O.OrderID)'Ukupno naruceno', SUM(OD.UnitPrice)'Ukupna cijena', C.Country+', '+C.City AS 'Iz'
 FROM Customers AS C
 JOIN Orders AS O ON C.CustomerID=O.CustomerID
 JOIN [Order Details] AS OD ON O.OrderID=OD.OrderID
 GROUP BY C.Country,C.City,C.ContactName
 HAVING SUM(OD.UnitPrice)>1000
 ORDER BY SUM(OD.UnitPrice) DESC
 
 --Sigurnost korisnickih racuna je kompromizovana te se moraju dodati novi sigurni password-i.
 USE pubs
 SELECT fname+' '+lname AS 'Ime',
 SUBSTRING(lname,3,3)+SUBSTRING(fname,3,2)+CONVERT(NVARCHAR,(ASCII(fname)+ASCII(lname))/(CHARINDEX('s',fname)+2))+REVERSE(UPPER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(lname,'a','#'),'e','$'),'i','&'),'o','^'),'u','+')))+RIGHT(CONVERT(NVARCHAR,DATEDIFF(SECOND,hire_date,GETDATE())),3) AS 'Novi password'
 FROM employee