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

Continue with the right access

“Analyze dates and periods” is included from SQL Essentials.

30 free days of SQL Pro on registration, subject to the 34 remaining places. No card or automatic renewal.

After signing in, you will return directly to this activity.