location_average_query.sql

select 
    date_part('year', timestamp)
    , avg(latitude) as average_lat
    , avg(longitude) as average_long 
from location_history
group by date_part('year', timestamp) 
order by 1 asc;