PLEASE ANSWER ONLY IF YOU KNOW HOW TO. DO NOT COPY AND PASTE FROM OTHER ANSWERS YOU WILL GET DOWNVOTED.

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.

PLEASE USE POSTGRES AND SOLVE IT USING WINDOW FUNCTIONS. YOU WOULD HAVE TO CONVERT GPS TO MPH