1
00:00:00,330 --> 00:00:00,920
All right.

2
00:00:00,930 --> 00:00:01,800
Welcome back.

3
00:00:02,009 --> 00:00:07,200
So in the last couple of sections, we focused on Select and we're going to continue that trend.

4
00:00:07,350 --> 00:00:12,180
In this section, we're going to talk about some of the other tools that we'll be able to use to get

5
00:00:12,180 --> 00:00:14,550
more specific when we're selecting things.

6
00:00:14,550 --> 00:00:20,160
So we'll be able to do things like sort our results that we get back in alphabetical order or reverse

7
00:00:20,160 --> 00:00:25,980
alphabetical order or limit the number that we get or only get unique results back and a bunch of other

8
00:00:25,980 --> 00:00:31,920
things that we'll be able to combine and use just as other tools in our arsenal or or weapons rather

9
00:00:31,920 --> 00:00:32,850
in our arsenal.

10
00:00:33,330 --> 00:00:39,750
So before we do that, though, I want to start by just adding a little bit more data to the books that

11
00:00:39,750 --> 00:00:40,980
we're currently working with.

12
00:00:41,310 --> 00:00:47,310
Basically, I want to have a bit more variety, so I'd like to insert three new books and they look

13
00:00:47,310 --> 00:00:48,030
like this.

14
00:00:48,420 --> 00:00:54,210
So we have one here 10% Happier by Dan Harris released in 2014.

15
00:00:54,210 --> 00:00:57,660
We have 29 in stock and it's 256 pages long.

16
00:00:58,620 --> 00:01:02,880
You'll see why we have that, why we're inserting that and just a couple of videos.

17
00:01:02,880 --> 00:01:07,140
But there is a reason we're going to come back to it and then we have a fake book.

18
00:01:07,140 --> 00:01:10,980
So just imagine that we're testing our system or something and we want to make sure it works.

19
00:01:10,980 --> 00:01:12,600
So we have fake underscore book.

20
00:01:12,780 --> 00:01:20,010
And then that's written by Frieda Harris in 2001, 287 copies in stock, 428 pages.

21
00:01:20,190 --> 00:01:26,700
And then this is actually one to I haven't read either of these, but this is one I just finished and

22
00:01:26,700 --> 00:01:28,050
that's one of the reasons I added it in.

23
00:01:28,080 --> 00:01:29,070
There's another one, though.

24
00:01:29,460 --> 00:01:34,170
It's really good, by the way, if you're looking for a book called Lincoln in the Bardo by George Saunders

25
00:01:34,170 --> 00:01:36,210
released just this year.

26
00:01:36,240 --> 00:01:39,360
And we have 1000 copies in stock because it's brand new.

27
00:01:39,360 --> 00:01:41,910
So we haven't sold any or we haven't sold many yet.

28
00:01:42,000 --> 00:01:47,130
Or maybe we're anticipating a big flood of sales and it's 367 pages.

29
00:01:47,280 --> 00:01:52,680
So either type that up or copy and paste it in the code is available along with this video and we're

30
00:01:52,680 --> 00:01:58,200
going to just copy and run over here, make sure that we're doing let's make sure we're working with

31
00:01:58,200 --> 00:01:59,700
the correct database.

32
00:02:01,100 --> 00:02:06,000
All right in bookshop and we'll just paste that in insert into books.

33
00:02:06,020 --> 00:02:06,900
Blah, blah, blah, blah, blah.

34
00:02:06,920 --> 00:02:08,539
We don't need to go over everything.

35
00:02:09,289 --> 00:02:11,800
All right, so we get three rows affected.

36
00:02:11,810 --> 00:02:16,180
Let's do a select title from books.

37
00:02:16,190 --> 00:02:17,760
Just make sure that we have those in there.

38
00:02:17,780 --> 00:02:18,470
Here we go.

39
00:02:19,100 --> 00:02:22,070
We had up to consider the lobster in the last section.

40
00:02:22,070 --> 00:02:25,640
Now we have 10% happier fake book and Lincoln in the Bardo.

41
00:02:26,060 --> 00:02:27,880
All right, so that's all I wanted to do here.

42
00:02:27,890 --> 00:02:29,990
I highly recommend that you go and do this.

43
00:02:29,990 --> 00:02:31,640
If you want to follow along.

44
00:02:31,910 --> 00:02:34,370
It will make the exercises much easier.

45
00:02:34,640 --> 00:02:39,230
It will make them possible in the first place, and you'll be able to type the code that I type on your

46
00:02:39,230 --> 00:02:39,380
own.

47
00:02:39,380 --> 00:02:43,620
So I highly recommend that you do it, but I guess you could just watch if you wanted to.

48
00:02:43,910 --> 00:02:46,850
So without further ado, let's get on to the new stuff.