Extra query 2

--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