Solution Review: Generating Series

In the challenge, you were asked to perform two tasks. Here we’re going to discuss the solution to these two tasks.

Task 1

You were asked to write a query to generate a series and check which year is a leap year. Your code should output the date, year, and leap columns. The date column will take the values starting from 2000-01-01.

Solution

Click the “Run” button in the following widget to see the output.