SQL, konsitente records ud af "en til mange" relationer

Hvad følgende (ikke testet):

på UserProfile niveau

select u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode, count (*) cnt
from UserProfile u
inner join Advertisement a on u.PK_UserProfileId = a.FK_UserProfileId
where u.ZipCode = 2200
group by u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode


på Advertisement niveau

select u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode, count (*) cnt
from UserProfile u
inner join Advertisement a on u.PK_UserProfileId = a.FK_UserProfileId
where a.TypeId = 1
group by u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode


på Advertisement_Zip niveau

select u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode, count (*) cnt
from UserProfile u
inner join Advertisement a on u.PK_UserProfileId = a.FK_UserProfileId
where a.AdvertisementId in (select FK_AdvertisementID from Advertisement_ZIP where ZipCode between 2100 and 2200)
group by u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode

Tusind tak, Kan det lade sige at lave et script der har kriterer på alle niveauer. Eller skal det brydes op som ovenfor?

Måske sådan her:

select u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode, count (*) cnt
from UserProfile u
inner join Advertisement a on u.PK_UserProfileId = a.FK_UserProfileId
where u.ZipCode = 2200
and a.TypeId = 1
and a.AdvertisementId in (select FK_AdvertisementID from Advertisement_ZIP where ZipCode between 2100 and 2200)
group by u.PK_UserProfileId UserProfileId, u.Name, u.Email, u.ZipCode