Selecting data with group by comparing arrays

statement_sql.rb

# @param [String] account_id
# @param [String] exclusions
def statement(account_id, exclusions = nil)
  <<-STATEMENT
SELECT 
	JSON_AGG(profiles.id) id, 
	JSON_AGG(users.external_id) external_id 
FROM profiles 
LEFT JOIN users ON users.id = profiles.user_id 
WHERE 
	profiles.role = 'Patient' 
	AND profiles.account_id = #{account_id} 
GROUP BY 
	profiles.account_id, 
	profiles.location_id, 
	LOWER(users.last_name), 
	users.date_of_birth 
HAVING 
  #{exclusions.present? ? "NOT(ARRAY[#{exclusions}] && ARRAY_AGG(users.external_id::TEXT)) AND " : ''} 
  COUNT(profiles.id) > 1;
STATEMENT
end