SQL beginner - no such table error


#1

I have just started trying to learn SQL with the lessons on codeacademy, but I am coming up with a ‘no such table error’ and I am not sure if it is something I am doing wrong or a bug in the system.

In the ‘writing queries’ lesson, the idea is that you go through several databases to learn how to write queries. Everything is fine for the first babies table, but when I try to write queries for the nomnom table (i.e. the restaurants table), it tells me there is no such table as nomnom, even if I copy and paste the code from the hint and run it.

Has the lesson got the name of the table wrong? Am I meant to remove the babies table and then load the nomnom table somehow? There is no instruction in the lesson how to do this


#2

Hey Mrtnwhite, I’m sure the community here will be happy to help, but we need a bit more context to be able to do so. For example, it’d help if you could give us the link to the exercise you’re talking about – without that, it’s hard to answer your question.

See this post for more details.


#3

https://www.codecademy.com/paths/data-science/tracks/sql-basics/modules/dspath-sql-queries/lessons/sql-queries-code-challenge/exercises/restaurants-i


#4

@mrtnwhite - have you had any resolution to your problem with the nomnom table being missing? I’m encountering it too.


#5

Nope, I got no help! I think the only thing that works for me is just reloading the webpage.