The place that I work at does a lot of querying with Msquery.

Is there any books/documentation online or otherwise that one can learn
Msquery. I checked Amazon with no luck.

For instance, does Msquery support certain functions (left, right, str,
etc) Does Msquery support aliases SELECT Avg(Price) AS 'PriceAverage'?
I've tried and I get invalid token errors.

Thanks.