common window function gotcha

window_function_inside_case_statement.sql

select *,
	case
		when confirmed_at is not null and price_dollars > 0
		then row_number() over (
			partition by user_id, price_dollars > 0
			order by confirmed_at
		)
		else null
	end as user_enroll_rank,
	case
        when confirmed_at is not null and price_dollars > 0
		then row_number() over (
            partition by learner_id, price_dollars > 0
            order by confirmed_at
        )
        else null
	end as learner_enroll_rank