Exercise 1 of 17

Count sequences from Switzerland

Fixed training server

Count all sequences from Switzerland.

The output should have this shape:

count
-----
1234

Write a query and run it. The result is compared with the reference answer without considering row order.

Loading query editor…
Explanation

Filter the table to sequences from Switzerland. Then, use groupBy without grouping columns to count all remaining rows.

Query pipelinesfilter and groupBy
Reference answer
default
  .filter(country = 'Switzerland')
  .groupBy({count:=count()})