如何确定几何范围内的平均停留时间

I have a database with device coordinate time-series (timestamp, x, y, device_id). How can I determine the longest dwell-time over multiple devices within an area and timeframe in SQL?I have a database with device coordinate time-s