SELECT * FROM Account
WHERE UserId IN
(SELECT UserId FROM [UserProfile]
WHERE AddressOfRegistrationId IN (SELECT Id FROM [Address] WHERE CountryId = 54)
AND DateCreated >= '2018-01-01 00:00:00' AND DateCreated < '2019-01-01 00:00:00')
AND
Id IN (SELECT AccountId FROM AccountTransaction);