SGL manipulation


#1

https://www.codecademy.com/courses/learn-sql-manipulation/lessons/manipulation/exercises/statements?action=resume_content_item&course_redirect=learn-sql

I was trying to do the second part of this exercise and I can not move on. I have done all that the instructions have told me to do what do I do?

thanks :wink::stuck_out_tongue_winking_eye:

also: do I have to do ALL CAPS for it to work?


#2

For it to pass, perhaps. For it to work, no.

create table celebs (id integer, name text, age integer);

However, it doesn’t hurt to follow convention from early on so it becomes second nature. The general convention is to use all caps on SQL keywords.

CREATE TABLE celebs (id INTEGER, name TEXT, age INTEGER);

Do you mean step 1? Or the next lesson where we insert a row into the table?


#3

oh I think I was able to fix that problem


#4

but why all caps. why is that needed?


#5

For that you might have to do some reading. I cannot come up with an answer other than as previously mentioned… Style Guide Convention.


#6

ok sound good!!:+1:t3::+1:t3::+1:t3: