7th Nearest Palindrome Coding

7th Nearest Palindrome

Given the input_values table, find the seventh nearest palindrome for every nonnegative input value. Exclude the input value itself when it is already a palindrome. Order ties by the smaller palindrome, and exclude NULL and negative inputs.

Output

1. One row per valid input value, with input_id, target_value, seventh_nearest_palindrome, and distance
2. Return the seventh candidate by ascending distance, then ascending palindrome value
3. Sort by input_id