select reverse(left(reverse(d.namespace),charindex('/',reverse(d.Namespace))-1)) as BaseDescriptor
,d.Namespace,d.CodeValue,d.Description,d.ShortDescription,d.DescriptorId 
from edfi.Descriptor d
order by 1,d.Namespace,d.DescriptorId