Mysql Where使用列别名

SELECT customer_id,group_id,email,SUM(grand_total) AS total_amount,COUNT(*) AS orders_num 
FROM sales_flat_order_grid    
LEFT JOIN customer_entity  ON customer_entity.entity_id = sales_flat_order_grid.customer_id   
WHERE `status`='complete' AND customer_id IS NOT NULL  AND customer_entity.group_id = 1 
GROUP BY customer_id    
ORDER BY orders_num DESC    

上面SQL查询结果如下：

需求：

我只需要orders_num这列值 >= 5的数据。

方法：在这个select外面 在套一个 select

SELECT SS.* FROM (
	#...上面那个SQL  
)SS
where SS.orders_num >=5 

最终如下：

SELECT SS.* FROM (
	SELECT customer_id,group_id,email,SUM(grand_total) AS total_amount,COUNT(*) AS orders_num 
	FROM sales_flat_order_grid    
	LEFT JOIN customer_entity  ON customer_entity.entity_id = sales_flat_order_grid.customer_id   
	WHERE `status`='complete' AND customer_id IS NOT NULL  AND customer_entity.group_id = 1 
	GROUP BY customer_id    
	ORDER BY orders_num DESC    
)SS
where SS.orders_num >=5