[CCCP]

Select
G.npizzas,
Max(G.cantidad)
From
(Select
npizzas,
Sum(Cantidad) as Total
From elaboracion
Group by npizzas) as G
group by G.npizzas