[ALUG] SQL question for the SQL gurus out there

I think there should be a way to do this but at the moment I can't see how, I always find SQL difficult to fathom though. I have a table with dates, times and temperatures in it. I want to select the maximum temperature for each year, how do I do that? The table has columns as follows:- ID Date Time Indoor Temperature Outdoor Temperature What I want to get out of it is something like:- 2014 21.23 2013 30.45 2012 25.31 It's a sqlite3 database so there's no procedural language easily available. I guess I could write a Python script to do what I want, that might be the easiest way. -- Chris Green