Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Aggregate functions

Moons

Report a typo

There is some statistical information about planets and their moons in this table:

planet moons is_dwarf
Varda 1 TRUE
Salacia NULL TRUE
Earth 1 FALSE
Ceres 0 TRUE
Eris NULL TRUE
Mars 2 FALSE
Mercury 0 FALSE
Pluto 5 FALSE
Haumea 2 TRUE

In the answer box, type in the results that these functions will return:

  • COUNT(moons)
  • COUNT(*)
  • COUNT(DISTINCT moons)

Please, do not change the order of the functions and separate the execution results by single spaces.

Enter a short text
___

Create a free account to access the full topic