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