WEBVTT

00:00.090 --> 00:02.410
So this is the read solution.

00:02.580 --> 00:05.760
Basically it's a bunch of select statements we're going to write.

00:05.760 --> 00:11.280
So the first one is to select all shirts but only print out their article and their color.

00:11.370 --> 00:12.920
So back in cloud 9.

00:13.140 --> 00:20.010
All we need to do is select and rather than just select star which gives us everything from all shirts

00:20.610 --> 00:25.500
I mean this is correct in that we want all shirts to be listed but we wanted to narrow down the fields

00:25.530 --> 00:30.770
we get which was Article comma color.

00:31.560 --> 00:32.910
And there we go.

00:33.120 --> 00:38.570
Article color T-shirt white polo shirt black tank top white and so on.

00:38.580 --> 00:46.170
Next up select all medium shirts but only print out shirt I.D. So that's all we want.

00:46.170 --> 00:52.740
So let's start off by just getting the medium shirts to select star from shirt wear.

00:52.790 --> 00:56.720
And then we need to do a shirt size equals medium.

00:56.910 --> 01:03.770
Just like that and hit enter and we get four shirts that have shirts heads of media.

01:03.900 --> 01:10.320
But all that we want is everything excluding the shirt Id just a moment ago I think I said it backwards

01:10.770 --> 01:16.420
on everything but the shirt ID which means we need to list everything we want out.

01:16.470 --> 01:28.050
So select article color comma shirt size comma last worn and then we can just copy this from shirts

01:28.970 --> 01:32.870
where shirts equals medium.

01:33.010 --> 01:34.150
And here we go.

01:34.360 --> 01:42.030
We have all mediums and we have the four columns we're looking for which excluded shirt ID sorry surety.

01:42.310 --> 01:46.520
So that's it for the selecting portion to read in our crowd.

01:46.630 --> 01:47.950
Next up update.