What's the equivalent of SELECT x FROM (SELECT...) ?

[jalbano]

I can't seem to find a way to do nested SELECTs - is it possible? I need to do 2 levels of "group by" which is why (I think) I need to do the nesting. The raw SQL works fine (but don't want to use rawQuery() because I have lots of conditions that tweak the query and manipulating the raw string gets messy.