Challenge: Generating Series
Explore how to use PostgreSQL's generate_series function to create date and numeric sequences. Learn to write queries to identify leap years within a series of dates and filter out specific numbers when generating a numeric sequence. This lesson helps you gain practical skills in using generate_series for data generation and filtering in PostgreSQL.
We'll cover the following...
We'll cover the following...
Problem statement
You will perform the following two tasks in this lesson:
Task 1
Write a query to check which year is a leap year, given a series of dates. Your code should output the date, year, and leap ...