1-- test placeholder: perl pg_format samples/ex9.sql -p '<<(?:.*)?>>'
2SELECT * FROM projects WHERE projectnumber in <<internalprojects>> and username = <<loginname>>;
3
4
5CREATE TEMPORARY TABLE tt_monthly_data AS
6WITH a1 AS (
7	SELECT * FROM test1
8)
9SELECT ROUND(AVG(t1)) avg_da, ROUND(AVG(t2)) FROM a1;
10