So now in SQL Compact 3.5 you can make queries against Northwind.sdf with the following syntax:
SELECT Top(10) *
FROM [Order Details]
ORDER BY [Unit Price] * Quantity DESC
And you will get the 10 most valuable orders listed.
It's nice to see this omission finally added to the SQL Compact syntax.