select avg((select 100 union select 200))
Returns 100 I would have expected 150? Am I being thick or is it a bug? -- View this message in context: http://www.nabble.com/Is-this-query-correct--t1829679.html#a4991615 Sent from the SQLite forum at Nabble.com.