CREATE TABLE table_54994 ("Position" FLOAT, "Album Title" TEXT, "Artist" TEXT, "Highest Position" FLOAT, "Sales" FLOAT)

What is the lowest high position for 10 years of hits, and over 870,000 sales?
SELECT MIN("Highest Position") FROM table_54994 WHERE "Album Title" = '10 years of hits' AND "Sales" > '870,000'
SELECT MIN("Highest Position") FROM "table_54994" WHERE "Album Title" = '10 years of hits' AND "Sales" > '870,000'