Preview
Video Player
00:00
00:00
Students A to M
2:00Generate a list of students with last names from A to M.
Awesome, and one more thing.
0:00
The printer ran out of ink when
printing sign-in sheets for
0:02
the first half of our students.
0:05
If you could get a list of students
with last names from A to M,
0:06
that would be really helpful.
0:10
For this query, let's start by
selecting a list of all the students.
0:13
SELECT* FROM STUDENTS.
0:17
Then, lets add a WHERE clause.
0:19
And in this WHERE clause,
0:21
we need to limit our students to only
the ones with last names from A to M.
0:22
But before we do that,
I'm gonna real quick add the ORDER BY and
0:27
we want to do it by LAST_NAME ASCENDING.
0:31
Okay, getting back to the WHERE clause,
if you google for
0:34
this answer,
one thing you might come across is this.
0:36
So using the LIKE keyword we
can do something like this.
0:40
A to M, and then the % sign,
and what these brackets mean,
0:43
is that the first character in the last
name needs to be between A to M.
0:48
And then the % sign again which know
means, whatever comes after this is fine.
0:54
So this is saying, the first character
needs to be between A to M, and
0:59
all the remaining characters
we don't care about.
1:02
However, if we try to run this,
It doesn't work.
1:05
And that's because the syntax
doesn't work with SQLite.
1:09
It works with most SQL implementations,
it just doesn't work with this one.
1:13
So we'll have to take
a different approach.
1:17
So, what we are going to do, is instead of
using the LIKE keyword, we're just going
1:20
to see if the last name is after, or equal
to, the letter A, and before the letter N.
1:24
And to do that, we can chose
greater than and equal to signs.
1:31
So, let's do LAST_NAME, and
let's make sure it comes after or
1:35
is equal to the letter A, and
let's make sure, so AND LAST_NAME.
1:41
We wanna make sure its
less than the letter N.
1:47
And if we run this, there we go.
1:50
Last names with A.
1:53
If we scroll all the way
down to the bottom,
1:54
we get this very last one with Murray.
1:57