All right.
Let's talk about our different selections We're going to perform.
There's just two of them here, I believe.
The first one is select all the shirts from the entire database, but only print out article and color.
So I'll do these directly in the show.
We'll start with select star from shirts.
That's all of them.
But I don't want everything.
Print it out.
I only want article and color.
So select article, comma, color from shirts.
And there we go.
We see all the articles and colors for all the rows.
And then the second piece, select all the medium shirts and don't print everything out.
Print everything but shirt ID.
So let's start with the where portion.
We'll do a select star from shirts where and then it is size equals medium.
Although I think we called it shirt size.
We'll find out really quickly here.
Unknown column size.
Honestly, shirt size is probably a bad name for that column.
It's kind of obvious.
It's a shirt size most likely.
So why not just call it size?
But there we go.
We match the column name precisely.
And we see we get what, four medium shirts?
But then we need to make sure we're only selecting certain columns, all of the columns except for shirt
ID, so I'm just going to list them out instead of Select Star.
I'm going to select article.
Color shirt size and last worn.
And that should do it.
We get article color, shirt size, last worn, no shirt ID for all the medium shirts.
There's only four of them.
All right.
Next up, we're going to talk about updating.