Explain the purpose of LAG and LEAD functions in SQL

Question Explain

This question tests knowledge of accessing previous or next row values without self-joins.