How to use SQL function such as Count/Min/Max in Cloud Application Programming

Hello Everyone,

Kindly let me how I can use SQL functions in CQL. How i can frame the CQL for the below -mentioned select query i

Sample Select Query with groupBy Clause and SQL Function

Select status,Count(status) as Count from foobar where createdon>= valid_from and createdon <= valid_to grouby(status)

I am referring the below-mentioned URL

https://cap.cloud.sap/docs/cds/cql

Thanks

Sandeep