Ad
  • Custom User Avatar

    In real scenarios you likely want a distinct in the count:

    select age, count(distinct id) as people_count
    from people
    group by age

    For some reason that doesn't work and does not return the right results in this kata.

  • Custom User Avatar

    Why do you need to order by species? It wouldn't accept my solution until I did but the problem description does not seem to indicate that it requires a specific order.