I would like to use subqueries in the From Clause so I can make aggregations within a subset of data.
SELECT * FROM (Select id From Module.Entity limit 0, 50)