对于满足SQL92标准的SQL语句： 
select foo，count（foo）from pokes where foo>10group by foo having count （*）>5 order by foo  
其执行顺序应该是（）。

A.FROM->WHERE->GROUP BY->HAVING->SELECT->ORDER BY
B.FROM->GROUP BY->WHERE->HAVING->SELECT->ORDER BY
C.FROM->WHERE->GROUP BY->HAVING->ORDER BY->SELECT
D.FROM->WHERE->ORDER BY->GROUP BY->HAVING->SELECT