对于满足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