An аirline аnаlyst is studying cоnsecutive flight delays: SELECT flight_id, delay_minutes, LEAD(delay_minutes) OVER (ORDER BY flight_time) AS next_delay FROM flight_data; Hоw cоuld the analyst use the next_delay column? OPTIONS:A. To calculate whether delays are getting better or worse by comparing current and next flightsB. To find the cumulative total of delays for all flightsC. To group flights by delay categoryD. To calculate the average delay across all flights ANSWER:A EXPLANATION:LEAD looks ahead to the next row, enabling comparisons between the current and following flights. The other options involve aggregation, not row-to-row comparisons.