In this section, we're going to learn all about different ways of narrowing our selections or refining
our selections, or at least manipulating them in some way to do things like order or sort our results,
or only get unique or distinct results to limit the number of results we get.
These are different things that we can add on to our queries to change how our selections behave.
But before we do that, I would like for us to add a couple of new books to our books table so that
we can have some clearer results.
You'll see what I mean as we make some more progress in the section.
But I would just copy and paste this or if you want to type it out yourself.
But there's a couple of things I want to highlight.
There's a percent sign here, so don't miss that.
And then we've got two authors that have the same last name, but they're not the same author.
One is Dan Harris, the other is free to Harris And just make sure you have the same numbers, the same
text and all that stuff.
Copy and paste this either from the slides or from the code following this video.
And I'm going to make sure I'm using the right books database.
So let's just do select database.
Bookshop and I should have the books table still.
Okay, I'll paste that and hit enter.
We'll do a select star from books.
And it's nasty to look at, but we see 10% happier fake book and Lincoln in the Bardo.
Great.
Next up, we're going to learn how to select distinct results.