Error Code: 1146 when creating new table desc

[J C]

I have a schema called "cia_data" and have 3 files in my database--Query 1, SQL File 3, SQL File 5.

With the code shown in the attached video, I had two errors. The first error was with DROP TABLE new_table, which made sense as it said it was Unknown (error code 1051) and was executed a few times to ensure my imported table would not be counted. I then typed and executed SQL File 5 and had issues because of the table "not existing" even after I created it. Does anyone have a solution to this? I need to fix this error to move on in my project.

Please see this video for more information: https://www.youtube.com/watch?v=UitvpKdanzo

P.S.: Can you attach images on this forum? That would be helpful as then I do not have to always create a YouTube video.

Thanks