sera esta:
Código SQL:
Ver originalSELECT orderid,CompanyName,ShipCountry,ShippedDate FROM Customers AS t1
LEFT JOIN
(
SELECT customerid,ShippedDate,orderid,ShipCountry
FROM orders WHERE CONVERT(VARCHAR(20),ShippedDate) + CONVERT(VARCHAR(20),ShipCountry) IN (
SELECT CONVERT(VARCHAR(20),MAX(ShippedDate)) + CONVERT(VARCHAR(20),ShipCountry) FROM orders GROUP BY ShipCountry
)) AS t2 ON (t1.customerid=t2.customerid)
WHERE t2.OrderID IS NOT NULL
saludos!