As of now only COUNT(*) is integrated. Make other aggregation functions such as SUM(col), AVG(col), MIN(col), MAX(col) work as well.
SELECT SUM(fare_amount) FROM yellow_tripdata
WHERE tpep_dropoff_datetime >= '2022-01-01T00:00:00Z'
AND tpep_dropoff_datetime < '2022-02-01T00:00:00Z'",