With derived tables, you can perform grouping of groups, or you can construct a join with a group, without having to create a view.

• 使用派生表,您可以对组进行分组或构造与组之间的连接而无需创建视图。