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.