Exercise

Counting numbers recursively

In this first exercise after the video, we will start with a very simple math function. It is the simple series from 1 to target and in our case we set the target value to 50.

This means the task is to count from 1 to 50 using a recursive query. You have to define:

the CTE with the definition of the anchor and recursive query and
set the appropriate termination condition for the recursion

Instructions

100 XP

Limit the recursion step to 50 in the recursive query.
Define the CTE with the name counting_numbers.
Initialize number in the anchor query.
Add 1 to number each recursion step.