Alongside greater than we of course, have less than.
So I'll keep this part brief.
It's pretty straightforward.
Let's select all the books released before the year 2000 and let's just get their title and released
here from books where released here is less than 2000.
And here they are.
We get five books, 96, 81, 89, 85, 45.
We could even do something like sort them if we wanted to write order by release tier.
And now we go from 1945 up to 1996.
So that's one example of less than, let's do one more, let's find the short books.
I don't know if we have any books that are shorter than 200 pages, select title comma pages from books
where pages is less than 200, and we do have some 198 176 181.
All right, So that's working.
The next thing I want to talk about is greater than or equal to and also less than or equal to.
So let's take a look at our books again.
And we've got.
Years here.
Released here?
Sure.
Let's say I want to find all the books released after 2010, but I also want to include 2010.
So one option would be this select star, or let's narrow it and just do title release here from books.
And then I could say where released year is greater than 2010.
But that is not inclusive.
It doesn't also include any rows that were released in 2010.
So I could do this, which is kind of janky 2009 and now I'm getting 2010.
But maybe there's also fractional 2,009.5 that would be included even though we don't have any of those.
So that's maybe not the best approach.
Instead, I can do greater than or equal to it's just greater than and then an equal sign immediately
after and then 2010.
So now this will include all rows where the value for release year is either 2010 exactly or anything
greater than 2010.
And there we are.
We see we get 20, 16, 12, 13, 14, 17, but also 2010.
And the same thing holds true for less than.
So if I did all books released before 1985, there's two of them, 81 and 45, but I'm pretty sure there's
a book released in 1985.
So if I do less than or equal to again, the equal sign comes after the lesson.
Now we include White Noise released in 1985.
Great book.
So just remember it is less than and then the equal sign or greater than and then the equal sign.
It is not this.
It's not that sad looking face or the arrow.
It is this here.