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