Second Oldest Sibling(s)

Problem Statement

Second Oldest Sibling(s) You are given a table named `siblings` holding the children of the Michaelson family together with their age differences. Ranks are assigned by birth date: the youngest child has `sibling_rank` 1, the next-youngest has rank 2, and so on. **The youngest sibling is 15 years old.** Each row stores `age_diff`, the difference in years between that sibling and the sibling directly younger than them; the youngest sibling has `age_diff` 0 because there is nobody younger. Ages are therefore obtained cumulatively: age of rank 1 = 15 age of rank 2 = age of rank 1 + age_diff of rank 2 age of rank 3 = age of rank 2 + age_diff of rank 3 ... Two siblings may share the same age, which happens when the older of the two has an `age_diff` of 0. They still receive different ranks, so `sibling_rank` is the primary key of the table. Task Write a query that returns the rank, the name and the age of the **second oldest** sibling(s). The sibling with the highest age is the oldest, the