LEAD_IGNORE_NULLS

This is the same as the LEAD function with the optional IGNORE NULLS. Refer LEAD