Hi, Can someone walk me through what the bold portion of the below script is doing or what it’s purpose is?
SELECT carrier, id,
FROM flights f
WHERE f.id < flights.id
AND f.carrier=flights.carrier) + 1
** AS flight_sequence_number**
Actually, I’m finished the sql intensive programme, but I can’t the difference between correlated and non-correlated. I mean, I understand the theory, but looking at the code how do I know if it is correlated or non correlated?