framework/resources/Functional/aggregates/aggregation/scalar/q13.sql

-- Left outer join and scalar aggregates on both sides
select
	count(*),
	count(distinct a.c_integer),
	count(distinct b.c_integer),
	count(distinct a.c_date),
	count(distinct b.c_date),
	sum(a.c_bigint),
	sum(a.c_integer),
	sum(b.c_bigint),
	sum(b.c_integer),
	avg(a.c_bigint),
	avg(b.c_integer)
from
        alltypes a 
		full outer join
	alltypes b
on 	(a.c_date = b.c_date)
where
        a.c_bigint = 884838034226544640
;