mybatis 动态sql 多表分组查询

废话不多说直接上例子：

<select id="selectBuildingMsgByTimeFromBeginToEndAndAreaName" parameterType="java.util.Map" resultType="com.pojo.BuildingPojo">
    SELECT b.props_and_uses_name as propsAndUsesName,
    COUNT(*) as constructionNumbers, 
    COUNT(b.building_area) as constructionTotalArea
    FROM tb_construction_info c
	LEFT JOIN tb_building_info b
	ON c.cid = b.cid
	<where> 
	<if test="beginTime != null or beginTime != '' and endTime!=null or endTime != ''">
		c.completion_date between #{beginTime,jdbcType=TIMESTAMP} and
		#{endTime,jdbcType=TIMESTAMP}
	</if>
	<if test="beginTime != null or beginTime != '' and beginTime==null or endTime != ''">
		AND c.completion_date > #{beginTime,jdbcType=TIMESTAMP} 
	</if>
	<if test="beginTime == null or beginTime