Okay.
Let's take a look at a potential solution for this people problem.
So first thing, we need to create the table using the create table statement with first name as a var
char 20 last name, var char with a 20 character limit and age as an int.
So let's do that.
I'm just working in the Kat app for now.
It's fine.
We're going to delete this at the end.
So we'll start off with the create table and we'll call it people.
And the first thing that we'll have is first name, which is fa fa fa fa 20.
Next thing is last name, which is the exact same.
And then finally we have age, which is an int, and then our closing parentheses.
Okay.
Let's just double check.
It worked.
Let's use describe people.
Cool.
First name.
Last name.
Age bar cha cha cha.
Perfect.
So now we're going to insert our first person, Tina Belcher, who is 13.
So insert into people.
And we'll start off.
Let's do first name, last name, age and then values.
And we'll do hoops.
Tina Belcher.
It was 13, right?
Okay we hit enter just double check that it worked select star from people there Tina is perfect.
Now we're going to insert our second person, Bob Belcher, who is 42.
And my instruction here was do it in a different order.
So we'll do an insert into people this time.
Let's do age.
Last name, first name.
Values.
So age was priority for Cochise, 42.
Last name is Belcher and first name is Bob.
Don't forget our semicolon.
Let's do our select again.
Perfect.
It worked out how I was supposed to.
Great.
So then the last insert we're going to do is a multiple insert.
We have Linda Belcher, Phillip Frond and Calvin fish odor.
Oh, boy.
It's just going to be a lot to remember.
Let's start off by just typing out the basics.
Insert into people and we'll do this one with first name, then last name, and then finally age just
like that.
Then we'll do values and we'll start off poof.
We'll start off with Linda Belcher, who is 45, I think it was.
And I'll do commas on the new line and then we'll go with.
Phillip frond.
And he is 45.
No, 38.
I made this too hard.
Lastly, we have Calvin Fish out here.
I'm just going to copy Fish Odor, who is 70.
Calvin.
Fish odor 70.
All righty.
And before I forget, I need a semicolon.
Perfect.
Let's do our select star again.
Have to use the up arrow a couple of times and we have Linda, Philip and Calvin belch different fish
odor.
45, 38, 70.
Perfect.
So that's it.
And I didn't specify this in the instructions, but let's go ahead and delete the table.
So that's drop table, people.
Goodbye to the Belcher's and the other two.
And we verify that it's gone.
If you tried to do select staff from people, we get an error.
But if we do show tables now, we only have cats.
All the people are gone.
Just left with cats.