framework/resources/Functional/joins/order_by/queries/q28.sql

select count(*),
		count(sq1.a1),
		count(sq2.a2),
		min(sq1.a1),
		max(sq1.a1),
		min(sq2.a2),
		max(sq2.a2),
		avg(sq1.a1),
		avg(sq2.a2)
from
        (select c_integer, c_date from j1 order by c_integer asc nulls last) as sq1(a1, b1)
        inner join
        (select c_integer, c_date from j2 order by c_integer desc nulls last) as sq2(a2, b2)
        on (sq1.a1 = sq2.a2);