SQL LEAD() PARTITION BY ISSUE

I have a JOIN on the following select statement in injected sql

JOIN (SELECT
    g.id,
    lead(g.id) over (partition by g.sid_grade ORDER BY g.ordering) AS next_id
FROM
    grade g
WHERE
    g.status = 'Active')

If I omit the g. prefix in the partition by clause, sid_grade is not found in the table