My question is the following:
SELECT li.nombre,
count(li.cantidad) as cantidad
FROM LINEA
GROUP BY li.nombre
The query returns this data:
Coca 19
Corona 9
Mandarina 12
Speed 8
I need a query that returns the maximum. In this case the query should return:
Coca - 19