So this is the Reid solution.
Basically, it's a bunch of select statements we're going to write.
So the first one is to select all shirts, but only print out their article and their color.
So back in cloud nine.
All we need to do is select and rather than just select star, which gives us everything from all shirts.
I mean, this is correct in that we want all shirts to be listed, but we wanted to narrow down the
fields we get, which was article comma, color, and there we go.
Article color t shirt, white, polo shirt black, tank, top white, and so on.
Next up, select all medium shirts, but only print out shirt ID.
So that's all we want.
So let's start off by just getting the medium shirts.
So select star from shirts wear and then we need to do a shirt size equals medium.
Just like that.
And we'll hit enter and we get four shirts that have shirt size of medium.
But all that we want is everything excluding the shirt ID.
Just a moment ago, I think I said it backwards.
We want everything but the shirt ID, which means we need to list everything we want out.
So select article color comma, shirt size, comma, last worn.
And then we can just copy this from shirts where shirt size equals medium.
And here we go.
We have all mediums and we have the four columns we're looking for which excluded shirt ID, sorry,
shirt ID.
So that's it for the selecting portion, the read in our CRUD.
Next up, update.