Error in my code but i turns out my code is correct?


#1

I wrote the follow code and was told there is an error in line 1 no such table as "origin" but when i click get code it gave me the same code. I am confuse

SELECT origin, id,
(SELECT COUNT(*)
FROM flights f
WHERE f.id < flights.id
AND f.origin=flights.origin) + 1
AS flight_sequence_number
FROM flights;


#2

I'm going to say that something slightly different than the code you ran. So similar that you could not notice the difference.


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.