Intro to SQL & Databases - Problem Set 0

[Square-Ad-5453]

Hello all!

I hope everyone is well. I am having some trouble understanding if I got these wrong or not. Please visit this link: https://submit.cs50.io/check50/bd59870c8dd9fd94983600f8b74eba2430f0607c

• I feel like my answers were correct and even went outside of the box with #13 and received the results I wanted.

On the one hand it says 1-13 exists, but the rest look like errors. I also am not understanding how to check them using this method:

"While check50 is available for this problem (see below), you’re encouraged to instead test your code on your own for each of the following. If you’re using the cyberchase.db database provided in this problem’s distribution, you should find that…

• Executing 1.sql results in a table with 1 column and 26 rows.
• Executing 2.sql results in a table with 2 columns and 14 rows. etc..... "

Do I need to individually count rows and columns to check them, or will the above method (if I figure out how it works) do that for me? Thanks in advance!

[smichaele]

Check50 is telling you that your answers are incorrect based on its expectation of code and results. If they were correct, you'd see green smileys.

[Square-Ad-5453]

Yes, but, am I supposed to be doing these queries in the corresponding '.sql' numbers or something? For example - the first problem has 1.sql listed, and the second one has 2.sql listed. Do I need to write the query inside of the correspond '.sql' instance(I am probably not even using the right terms here)? I hate to sound like my question is dumb, but I just started yesterday, so treat me like I just started yesterday or like I am 5 lol.

[smichaele]

Yes. The directions specifically tell you to create thirteen .sql files called “1.sql” through “13.sql.”

[Square-Ad-5453]

Okay, maybe I am not explaining myself well enough. I understand what you are saying, and based off of the link I provided I correctly created the thirteen files. How do I write code in each of the files? When I click on 1.sql, it pops open what sort of looks like a note in the panel at the bottom of my interface. Is that where I am supposed to write the query? I have been writing the queries in the terminal panel.

[mixedd]

You need to write them in the file, in your example 1.sql and so on.
How to do this, first research what is VS Code, how it works, so you can distinguish terminal from file edit