Learn Practice Projects Free datasets Resources Toolkit Pricing

Log in Start free

Loading…

Hands-on analytics engineering training with browser-based practice, guided projects, and a human-reviewed capstone.

support@analyticsengineering.com

Learn

The course
Roadmap
Practice
Projects
Free datasets
Resources
Templates
Open-source toolkit
Jobs
Job market data
Guides
Glossary
Compare tools
Starting-point quiz

Topics

Analytics Engineering
SQL
dbt
Data Modeling
BigQuery
Snowflake
Looker
Python
Career
Interview Prep

Company

About
1-on-1 coaching
Pricing
Log in
Start free

© 2026 Analytics Engineering · All rights reserved

Terms Privacy Built by Routeless

SQL: Date and Time Functions

SQL: Date and Time Functions

10 exercises·3 free

01Extract Year From Order Date
Free→
02Calculate How Many Days Old Each Order Is
Free→
03Filter Orders Within A 30-Day Window
Free→
04Add Six Months To The Order Date
Locked→
05Extract The Month And Day From An Order Date
Locked→
06Display Order Date In YYYY-MM-DD Format
Locked→
07Compute Years Since Hire Date
Locked→
08Filter Orders In A Specific Quarter
Locked→
09Find Orders Within A Date Range
Locked→
10Show The Day Of The Week
Locked→