>But my questions are
>1. Doesn't the above code make the COUNT to be executed twice (thus increasing the time of the execution)
Nope
>2. Why in case of VFP using the calculated name (AS) works? Does it mean that with VFP data the execution time would be better?
Because in VFP the result cursor is created by parser BEFORE the query (this is just a guess).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.