I have this SQL:

DECLARE @NoSite Integer
DECLARE @NoAlbum Integer

SET @NoSite=2
SET @NoAlbum=0

SELECT TOP 3 Event.Title,Event.Url,Event.NoProvince,Province.Code,Event.City,Event.Date,Event.NoCompany,
 Company.Title AS Company,Event.Url,Event.NoAlbum,Album.Url AS AlbumUrl,
 (SELECT COUNT(*) FROM Photo WHERE Album.Numero=Photo.NoAlbum) AS PhotoCount
 FROM Event (NOLOCK)
 LEFT JOIN Province ON Event.NoProvince=Province.Numero
 LEFT JOIN Company ON Event.NoCompany=Company.Numero
 INNER JOIN Album ON Event.NoAlbum=Album.Numero
 WHERE Event.NoSite=@NoSite AND Event.NoAlbum>@NoAlbum
 ORDER BY Event.Date DESC 

I need to adjust it so to add a condition on PhotoCount>=7. I thought Having would do it but this doesn't work.