SELECT profiles.location
FROM users
JOIN profiles ON profiles.id = users."profileId"
WHERE
	"users"."deletedAt" IS NULL AND
	"offboarded" = FALSE AND
	"userType" = 'agent'
GROUP BY profiles.location
ORDER BY profiles.location;