SELECT temp.customerNumber, country, AVG(timeShipped) AS avgTimeShipped
FROM (
	SELECT customerNumber, shippedDate - orderDate AS timeShipped
	FROM orders
) AS temp
JOIN customers c ON temp.customerNumber = c.customerNumber
GROUP BY customerNumber
ORDER BY country, avgTimeShipped DESC;