Lesson 9 of 20

Analyze dates and periods

Filter for an unambiguous period and build repeatable monthly indicators.

32 minSQL Essentials

By the end of this lesson

  • Filter a period with an exclusive upper bound
  • Extract year and month
  • Group events by period

SQL Essentials

Unlock this lesson and continue the path.

Analyze dates and periods is part of the complete programme: 20 lessons, 44 verifiable exercises and 2 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.