Given the following sql table
| id | name | mother | father | brothers |
|----|-------|--------|--------|-----------|
| 1 | danny | 3 | 2 | {4, 6, 7} |
| 2 | bob | 20 | 30 | {} |
| 3 | marge | 10 | 50 | {} |
| 4 | rose | 3 | 2 | {1, 6, 7} |
I want to get the names of the siblings of danny (id: 1).
I can do it with 2 queries and the help of programming language, making 1 query like
SELECT mother, father, brothers
FROM people
WHERE id = 1
then process it and do
SELECT name
FROM people
where id IN (3, 2, 4, 6, 7)
but I wonder if I could achieve the same result with a single query.