Retrieval using standard aggregate functions

Using the SELECT command to return data and apply standard aggregate functions.

• A table cyclist_points records the race points for cyclists.

  cqlsh> CREATE TABLE cycling.cyclist_points (id UUID, firstname text, lastname text, race_title text, race_points int, PRIMARY KEY (id, race_points );

  
• Calculate the standard aggregation function sum to find the sum of race points for a particular cyclist. The value of the aggregate will be returned.

  cqlsh> SELECT sum(race_points) FROM cycling.cyclist_points WHERE id=e3b19ec4-774a-4d1c-9e5a-decec1e30aac;

  
• Another standard aggregate function is count. A table country_flag records the country of each cyclist.

  CREATE TABLE cycling.country_flag (country text, cyclist_name text, flag int STATIC, PRIMARY KEY (country, cyclist_name));

  
• Calculate the standard aggregation function count to find the number of cyclists from Belgium. The value of the aggregate will be returned.

  cqlsh> SELECT count(cyclist_name) FROM cycling.country_flag WHERE country='Belgium';