In post 2 you gave the order statement "ORDER BY ProductPrice, ProductEuroPrice DESC" which will show highest priced products first.
1. For products with the same price, are they ordered by ProductID ascending by default?
2. How do you apply a different order to products with the same price?