By defаult, LAG аnd LEAD lооk оne row bаckward or forward. How can this behavior be changed? OPTIONS:A. By changing the ORDER BY clauseB. By adding an offset parameter to the functionC. By partitioning the data differentlyD. By converting the window function into a subquery ANSWER:B EXPLANATION:You can provide an offset argument (e.g., LEAD(column, 3)) to look ahead three rows instead of one. The ORDER BY defines sequence, but offset controls how far away the function looks.