1
00:00:00,060 --> 00:00:02,480
So this is the Reid solution.

2
00:00:02,490 --> 00:00:05,220
Basically, it's a bunch of select statements we're going to write.

3
00:00:05,640 --> 00:00:11,290
So the first one is to select all shirts, but only print out their article and their color.

4
00:00:11,310 --> 00:00:12,720
So back in cloud nine.

5
00:00:13,050 --> 00:00:20,220
All we need to do is select and rather than just select star, which gives us everything from all shirts.

6
00:00:20,460 --> 00:00:25,140
I mean, this is correct in that we want all shirts to be listed, but we wanted to narrow down the

7
00:00:25,140 --> 00:00:32,340
fields we get, which was article comma, color, and there we go.

8
00:00:33,090 --> 00:00:38,380
Article color t shirt, white, polo shirt black, tank, top white, and so on.

9
00:00:38,400 --> 00:00:44,460
Next up, select all medium shirts, but only print out shirt ID.

10
00:00:45,030 --> 00:00:46,190
So that's all we want.

11
00:00:46,200 --> 00:00:48,690
So let's start off by just getting the medium shirts.

12
00:00:48,690 --> 00:00:56,640
So select star from shirts wear and then we need to do a shirt size equals medium.

13
00:00:56,910 --> 00:00:57,810
Just like that.

14
00:00:57,810 --> 00:01:03,780
And we'll hit enter and we get four shirts that have shirt size of medium.

15
00:01:03,780 --> 00:01:08,220
But all that we want is everything excluding the shirt ID.

16
00:01:08,550 --> 00:01:10,590
Just a moment ago, I think I said it backwards.

17
00:01:10,590 --> 00:01:16,140
We want everything but the shirt ID, which means we need to list everything we want out.

18
00:01:16,290 --> 00:01:24,060
So select article color comma, shirt size, comma, last worn.

19
00:01:24,750 --> 00:01:30,600
And then we can just copy this from shirts where shirt size equals medium.

20
00:01:32,950 --> 00:01:34,030
And here we go.

21
00:01:34,180 --> 00:01:41,290
We have all mediums and we have the four columns we're looking for which excluded shirt ID, sorry,

22
00:01:41,290 --> 00:01:41,980
shirt ID.

23
00:01:42,190 --> 00:01:46,520
So that's it for the selecting portion, the read in our CRUD.

24
00:01:46,540 --> 00:01:48,130
Next up, update.