SELECT name, color, count(name) as c FROM fruit GROUP BY name HAVING c >= 2 ORDER BY fruit;