( dotnetlinux | 2016. 04. 08., p – 10:03 )

SELECT a, (SELECT AVG(b) FROM t1 AS subt1 WHERE subt1.dat < mastert1.dat) FROM t1 AS mastert1