Introduction
Dates
Time
15. TIME – additional practice
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Revision

Instruction

Alright, how about some additional practice?

Exercise

Show the average distance of all routes which depart after 8 AM.

Stuck? Here's a hint!

Use avg(x) to find the average value of x.

Console

Code editor

Result

TableConsole