单选题

其执行顺序应该是?

Question

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