SELECT 
    m.GroupID, 
    v.CompanyName, 
    COUNT(*) AS Count
FROM 
    maintable_PCDRE m
JOIN 
    cb_vendorinformation v 
ON 
    m.GroupID = v.GroupID
GROUP BY 
    m.GroupID, v.CompanyName
ORDER BY 
    Count ASC, m.GroupID DESC;