user: ### NOW ANSWER:
Question: What is the lowest high position for 10 years of hits, and over 870000 sales?
Columns: ['Position', 'Album Title', 'Artist', 'Highest Position', 'Sales']
Types: ['real', 'text', 'text', 'real', 'real']
Sample row: [1.0, 'Scissor Sisters', 'Scissor Sisters', 1.0, 1594259.0]
SQL:

assistant: SELECT MIN("Highest Position") FROM "Table" WHERE "Album Title" = '10 years of hits' AND "Sales" > 870000.0;