select DISTINCT  Customer.SupportRepId from Customer; 


#zapisi stevilo racunov po posameznem zaposlenem
select Employee.EmployeeId,Employee.FirstName, sum(das.st) as st_prodaj  from (
select c.CustomerId as cid,count(i.InvoiceId) as st,c.SupportRepId as csr
from Customer c
inner join Invoice i on
c.CustomerId = i.CustomerId
group by cid) as das,Employee
where Employee.EmployeeId =das.csr
GROUP BY Employee.EmployeeId

#zapisi stevilo minut skladb na posameznem predvajalnem seznamu
select p.PlaylistId , p.Name , sum(t.Milliseconds) from Playlist p 
inner join PlaylistTrack pt on pt.PlaylistId =p.PlaylistId 
inner join  Track t on t.TrackId = pt.TrackId
group by p.PlaylistId 

#izpisi koliko skladb je posameznega ?anra
SELECT count(Track.TrackId),Genre.name from Track,Genre
WHERE Genre.GenreId =Track.GenreId
group by Genre.Name;


#zapisi stranke ki imajo skrbnika/zaposlenega iz dolo?enega mesta(izbeeri si eno mesto sam)
SELECT Customer.firstname,Customer.lastname,Employee.city from Customer,Employee
WHERE Customer.SupportRepId = Employee.employeeid AND Employee.city="Calgary";

#Zapisi skladbe,ki so na istem ra?unu bile prodane vsaj2-krat
SELECT Track.name,InvoiceLine.Quantity  from Track,InvoiceLine
Where Track.TrackId =InvoiceLine.TrackId  AND InvoiceLine.Quantity>=2;


#zapisi skupno dol?ino skladb izbranega umatnika(Artist)
select a.Name,sum(t.Milliseconds) as Cas_trajanja  from Artist a 
inner join Album a2 on 
a2.ArtistId =a.ArtistId 
INNER JOIN Track t on
t.AlbumId = a2.AlbumId
where a.Name='Santana'
GROUP BY a.Name 
#Zapisi vse stranke ,ki imajo po?to tipa hotmail
SELECT Customer.FirstName,Customer.LastName from Customer
WHERE Email  like "%@hotmail.com";

#zapisi vse racune ,ki imajo skupno ceno ve?jo od 5?
SELECT Invoiceid from Invoice WHERE total>5;