Introduction
Points
Linestrings
Polygons
Summary

Instruction

It's time for some additional practice.

Exercise

Mark really took a liking to bicycle trips. However, he would like to plan them a bit better and always finish in the same place where he started.

Find the total number of bicycle routes that start and end at the same point.

Stuck? Here's a hint!

Use the functions ST_StartPoint and ST_EndPoint in a WHERE clause.

Console

Code editor

Result

TableConsole