Is it possible to contruct a SQL call with nested selects where each nested select acts on each item returned by the parent select?
Nested selects are posible, they must be enclosed in parenthesis. There may be other restrictions. I can't answer the rest of your question.
Retrieving data ...