doc/modules/cassandra/examples/CQL/min_max.cql

SELECT MIN (players), MAX (players) FROM plays WHERE game = 'quake';