SELECT * FROM airports WHERE id = 17107; - What's wrong?

SELECT * FROM airports WHERE id = 17107;

This is a simple query where I’m trying to query the airport ID however it’s not showing up. What’s wrong with this query? Where is the syntax error at? I’m on the airport problem.

@javacoder44363,
Could you provide the link to the lesson/section…

https://www.codecademy.com/en/courses/sql-table-transformation/lessons/subqueries/exercises/non-correlated-ii?action=resume

I’m trying to test my own code out on the online platform, but something like this already gives an error -_-. This query is purely for my own testing purpose, irrelevant to the problem. Maybe there are certain restrictions for querying?

NEVERMIND! I think I got the answer, it looks like that’s a valid query but the ID just doesn’t exist.

@javacoder44363,
You could have a look at the table-definition
+++ show all table defintions
select * from sqlite_master;

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