framework/resources/Functional/window_functions/negative/q9.sql

-- with the alias
select a2, max(distinct a2) over() as xyz from t2;