Yes in newest versions it does. But for any non-trivial analytics you would use Apache Spark (most likely Spark/SQL).

Cassandra's CQL is very limited in terms of types of queries it supports.

Yes, Cassandra supports common aggregation functions as well as user-defined aggregators which have to be created in Java.