MySQL - Problema con query,ayuda

Hola,tengo la siguiente query por resolver:

// From all the cancelled orders in classic models show the following:
// order Number, Name of the last product in that order, Number of products

select o.orderNumber, p.productName, max(od.orderLineNumber)
from orders as o
inner join orderdetails as od
on o.orderNumber = od.orderNumber
inner join products as p
on p.productCode = od.productCode
where o.status = "Cancelled"
group by o.orderNumber
order by 1, 2;

Alguien tiene alguna idea brillante de cómo ordenar los resultados de productname con los resultados de Max(od.orderlinenumber)???

Acepto sugerencias,muchas gracias.