From now need to be done SQL query + javascript function few hours job

From now soon, I'm looking for a SQL Query set of queries + a javascript function to calculate user's home location: A database includes rows with the following columns (realnames, will be given after the project): Table locations - latitude, longitude - timestamp Table activity - stationary: true/false - timestamp Table event - charging: true / false - timestamp Table wifi - SSID - timestamp I need a function in javascript that calculates a user home location based on the following rules: - stationary in the same place (or with a radius of 300m) - 5 days in a row in the last 10 days window - during at least 5 hours in row between 9pm and 6am - there's at least one a day (on the 5 mentioned days) a charging TRUE event during the period at the location - there's at least one a day (on the 5 mentioned days) the SSID is the same during the mentioned period Please consider that the queries results will be passed to the javascript and you would need to iterate over the data structure to get to the result.