1 00:00:00,350 --> 00:00:02,420 Finally for your last question, 2 00:00:02,420 --> 00:00:06,010 we'd like you to figure out which students have last names starting with A. 3 00:00:07,620 --> 00:00:10,150 For this query, we're getting back to the students table. 4 00:00:10,150 --> 00:00:16,550 So let's start by selecting all of the students, SELECT * FROM STUDENTS. 5 00:00:16,550 --> 00:00:19,180 Then we need to add a where clause to give us 6 00:00:19,180 --> 00:00:22,420 only the students with last names starting with A. 7 00:00:22,420 --> 00:00:26,340 So let's add WHERE, and then the last name column. 8 00:00:26,340 --> 00:00:28,900 And all that's left is we need to find a way to filter this 9 00:00:28,900 --> 00:00:31,940 to only show the last names starting with A. 10 00:00:31,940 --> 00:00:34,020 To do this, we can use the LIKE keyword. 11 00:00:35,730 --> 00:00:40,226 And we wanna show last names that are like the following, A%. 12 00:00:40,226 --> 00:00:45,161 And what this means, is that we're only to going to get names that have the first 13 00:00:45,161 --> 00:00:49,965 character as the capital A, and from then on out, it can be whatever we want. 14 00:00:51,035 --> 00:00:55,255 So, this query will give us only students with last names starting with A. 15 00:00:55,255 --> 00:00:57,235 So, let's add a semicolon and run it. 16 00:00:59,430 --> 00:01:02,520 And there we go, a bunch of students with last names starting with A. 17 00:01:03,900 --> 00:01:07,110 So, for example, if we wanted to show students with last names that 18 00:01:07,110 --> 00:01:11,103 end with the letter E, we could do % and then an E. 19 00:01:12,310 --> 00:01:14,070 And let's see what happens if we use a capital E. 20 00:01:16,130 --> 00:01:17,640 It looks like it works. 21 00:01:17,640 --> 00:01:20,950 Here's a bunch of students with last names that end with E. 22 00:01:20,950 --> 00:01:21,570 Pretty cool? 23 00:01:23,730 --> 00:01:24,650 Awesome work. 24 00:01:24,650 --> 00:01:28,040 From everything I can see, it looks like you're really good at this, 25 00:01:28,040 --> 00:01:32,070 though things always get a bit more challenging once the school year begins. 26 00:01:32,070 --> 00:01:36,210 In the next part of the course, we'll practice joining between multiple tables 27 00:01:36,210 --> 00:01:38,350 and tackle some more advanced reports, 28 00:01:38,350 --> 00:01:42,540 like how many students the school can hold and which teachers teach eighth grade.