[Solved] Formulate SQL query

After a while I got the right solution.
The key was to use multiple selects and it worked like a charm.