GENERATE_SERIES for sequence creation in PostgreSQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to generate a sequence of numbers from 1 to 5.

PostgreSQL

SELECT [1](1, 5);

Drag options to blanks, or click blank then click option'

ACREATE_SERIES

BGENERATE_SERIES

CSERIES_GENERATE

DMAKE_SERIES

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong function name like SERIES_GENERATE.

Trying to use CREATE_SERIES which does not exist.

The GENERATE_SERIES function creates a sequence of numbers between the start and end values.

2fill in blank

medium

Complete the code to generate a sequence from 10 to 50 with a step of 10.

PostgreSQL

SELECT * FROM GENERATE_SERIES(10, 50, [1]);

Drag options to blanks, or click blank then click option'

A5

B20

C15

D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a step smaller or larger than 10 which changes the sequence.

Omitting the step argument.

The third argument in GENERATE_SERIES is the step size. Here, 10 means the sequence increases by 10 each time.

3fill in blank

hard

Fix the error in the code to generate a sequence from 5 to 1 decreasing by 1.

PostgreSQL

SELECT * FROM GENERATE_SERIES(5, [1], -1);

Drag options to blanks, or click blank then click option'

A0

B6

C1

D-1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 as the end value which excludes 1.

Using a positive step with decreasing sequence.

To generate a decreasing sequence from 5 down to 1, the end value must be 1, and the step is -1.

4fill in blank

hard

Fill both blanks to generate a sequence of odd numbers from 1 to 9.

PostgreSQL

SELECT * FROM GENERATE_SERIES([1], [2], 2);

Drag options to blanks, or click blank then click option'

A1

B2

C9

D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using 2 as start which generates even numbers.

Using 10 as end which excludes 9.

The sequence starts at 1 and ends at 9 with a step of 2 to get odd numbers.

5fill in blank

hard

Fill all three blanks to generate a sequence of letters from 'a' to 'e' using ASCII codes.

PostgreSQL

SELECT CHR([1] + i) FROM GENERATE_SERIES(0, [2], [3]) AS s(i);

Drag options to blanks, or click blank then click option'

A96

B4

C1

D97

Attempts:

3 left

💡 Hint

Common Mistakes

Using 96 as base, which gives '`' (96) for i=0 instead of 'a'.

Using wrong step or end value that misses letters.

ASCII code for 'a' is 97, so use 97 as base. The series goes from 0 to 4 with step 1 to get letters 'a' (97+0) to 'e' (97+4=101).