CREATE TABLE table_name_22 (Highest NUMBER, album_title VARCHAR2, sales VARCHAR2)

What is the lowest high position for 10 years of hits, and over 870,000 sales?
SELECT MIN(Highest) AS position FROM table_name_22 WHERE album_title = "10 years of hits" AND sales > 870 OFFSET 000
SELECT MIN("Highest") AS "position" FROM "table_name_22" WHERE "10 years of hits" = "album_title" AND "sales" > 870 OFFSET 000 ROWS