Ver originalSELECT MAX(total),modelo FROM(SELECT COUNT(*) AS total, modelo FROM tabla GROUP BY modelo)AS t1