what I want to query for here is my large points of change in directionality (1:00 and 1:15) ... Yes I know I could use max and min if I wanted to specify an appropriate time window but I dont want to do this I want to find multiples of these types of numbers in the set (i.e. there can be 3-4 directionality changes in the set).
I know how to do this in code on my own using curve fitting but figured there might be a way to do this in SQL? as the data is already in SQL this would be a bit easier than me reading it out and doing libear calculations on it. Suggestions for linear analysis are welcomed as well (hence put in the math section)