count Unread By Tenant And User
@Query(value = "
SELECT COUNT(n) FROM Notification n
WHERE n.tenantId = :tenantId
AND (n.userId IS NULL OR n.userId = :userId)
AND n.read = false
" )