1
00:00:00,150 --> 00:00:02,880
Alongside greater than we of course, have less than.

2
00:00:02,880 --> 00:00:04,410
So I'll keep this part brief.

3
00:00:04,410 --> 00:00:06,210
It's pretty straightforward.

4
00:00:06,450 --> 00:00:12,330
Let's select all the books released before the year 2000 and let's just get their title and released

5
00:00:12,330 --> 00:00:18,990
here from books where released here is less than 2000.

6
00:00:20,050 --> 00:00:21,020
And here they are.

7
00:00:21,040 --> 00:00:26,050
We get five books, 96, 81, 89, 85, 45.

8
00:00:26,140 --> 00:00:31,660
We could even do something like sort them if we wanted to write order by release tier.

9
00:00:32,229 --> 00:00:35,460
And now we go from 1945 up to 1996.

10
00:00:35,470 --> 00:00:39,760
So that's one example of less than, let's do one more, let's find the short books.

11
00:00:39,760 --> 00:00:48,850
I don't know if we have any books that are shorter than 200 pages, select title comma pages from books

12
00:00:48,850 --> 00:00:57,730
where pages is less than 200, and we do have some 198 176 181.

13
00:00:58,150 --> 00:00:59,950
All right, So that's working.

14
00:01:00,220 --> 00:01:06,820
The next thing I want to talk about is greater than or equal to and also less than or equal to.

15
00:01:07,540 --> 00:01:10,780
So let's take a look at our books again.

16
00:01:12,120 --> 00:01:13,770
And we've got.

17
00:01:14,840 --> 00:01:16,160
Years here.

18
00:01:16,160 --> 00:01:17,390
Released here?

19
00:01:17,420 --> 00:01:17,840
Sure.

20
00:01:17,840 --> 00:01:24,170
Let's say I want to find all the books released after 2010, but I also want to include 2010.

21
00:01:24,170 --> 00:01:31,340
So one option would be this select star, or let's narrow it and just do title release here from books.

22
00:01:31,460 --> 00:01:36,200
And then I could say where released year is greater than 2010.

23
00:01:36,710 --> 00:01:38,390
But that is not inclusive.

24
00:01:38,390 --> 00:01:42,980
It doesn't also include any rows that were released in 2010.

25
00:01:43,460 --> 00:01:48,950
So I could do this, which is kind of janky 2009 and now I'm getting 2010.

26
00:01:49,220 --> 00:01:56,240
But maybe there's also fractional 2,009.5 that would be included even though we don't have any of those.

27
00:01:56,240 --> 00:01:58,610
So that's maybe not the best approach.

28
00:01:58,610 --> 00:02:03,680
Instead, I can do greater than or equal to it's just greater than and then an equal sign immediately

29
00:02:03,680 --> 00:02:06,110
after and then 2010.

30
00:02:06,410 --> 00:02:13,160
So now this will include all rows where the value for release year is either 2010 exactly or anything

31
00:02:13,160 --> 00:02:14,390
greater than 2010.

32
00:02:14,750 --> 00:02:15,620
And there we are.

33
00:02:15,650 --> 00:02:20,870
We see we get 20, 16, 12, 13, 14, 17, but also 2010.

34
00:02:21,290 --> 00:02:23,930
And the same thing holds true for less than.

35
00:02:23,930 --> 00:02:33,230
So if I did all books released before 1985, there's two of them, 81 and 45, but I'm pretty sure there's

36
00:02:33,230 --> 00:02:35,240
a book released in 1985.

37
00:02:35,240 --> 00:02:40,010
So if I do less than or equal to again, the equal sign comes after the lesson.

38
00:02:40,520 --> 00:02:43,700
Now we include White Noise released in 1985.

39
00:02:43,790 --> 00:02:44,570
Great book.

40
00:02:45,380 --> 00:02:50,360
So just remember it is less than and then the equal sign or greater than and then the equal sign.

41
00:02:50,360 --> 00:02:51,680
It is not this.

42
00:02:52,660 --> 00:02:55,780
It's not that sad looking face or the arrow.

43
00:02:55,810 --> 00:02:57,040
It is this here.