Imagine you have a database table with columns: phoneid, time, gps_latitude, gps_longitude.

Assume these records are logged approximately every few seconds for every phone. Your task is to detect speeding:

Write a database query (in SQL) to find anyone whose *average* speed is between 90 and 200mph for at least a minute. If can't write SQL query, write detailed procedural speudo code (assume input is coming from a comma delimited text file).