Yes, it's possible, but it depends on what you want it to look like. You first query will return a result set like:

ThemeA

ThemeB

ThemeC

The second will be like:

Theme2A

Theme2B

Theme2C

Theme2D

The third will be like:

7

How do you wish to combine those three result sets? Some sample data and table DDL would be very helpful here.

John