SQL: Data Transformation (6/7)


#1

Similar to exercise (4/7), exercise (6/7) omits needed information on how to complete the lesson.

Questions:

  1. What does the +1 do? I’m going to take a guess and say it is a way of saying make the sequence id number 1 more greater than the previous one.

  2. The ‘FROM flights f’ part, what is that doing? Is this the table naming itself as f?

  3. Any brief summary of the code going step-by-step or extra information would be appreciated!

-Thanks