Question: Using the online SQL site above, do the following: Execute the provided code that is pre - populated on the site. Change the Select statement
Using the online SQL site above, do the following:
Execute the provided code that is prepopulated on the site.
Change the Select statement to use all the column names instead of and execute this code with your changes.
Take a screen shot of the updated code with results.
Note For the following tasks, you will likely need to "reload" this page for these tasks to be done. Reloading will reset the DB session.
Reload the web session but do not execute.
Change the Create statement to the following.
CREATE TABLE NAMESId integer PRIMARY KEY, FirstName text, LastName text;
Modify the Insert Statements to include data for the new column. Note the text data is surrounded by single quotes. Do this for all the insert statements. You are free to use any names you wish.
INSERT INTO NAMES VALUES'Tom','Thumb';
Modify the provided Select statement to use the FirstName and LastName columns and execute this code.
Take a Screen shot of the code and results
Add a comment to your submission explaining why the column ID is not included in the INSERT commands.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
