#_title# SELECT COALESCE( seg.segment, 'Unassigned' ) segment, COUNT( cho.cho_segmentId ) segCount FROM tbl_CHO_Operators cho LEFT OUTER JOIN tbl_OPR_Segments seg ON cho.cho_segmentId = seg.SegmentID GROUP BY seg.segment, cho.cho_segmentId ORDER BY COUNT( cho.cho_segmentId ) DESC
class="danger">
Segment Count
#listLast( segment, "/" )# #segCount#