WEBVTT 00:00.330 --> 00:00.920 All right. 00:00.960 --> 00:01.850 Welcome back. 00:02.160 --> 00:07.800 So in the last couple of sections we focused on select and we're going to continue that trend in this 00:07.800 --> 00:08.380 section. 00:08.400 --> 00:13.440 We're going to talk about some of the other tools that we'll be able to use to get more specific when 00:13.440 --> 00:14.510 we're selecting things. 00:14.730 --> 00:20.130 So we'll be able to do things like sort our results that we get back in alphabetical order or reverse 00:20.130 --> 00:25.950 alphabetical order or limit the number that we get or only get unique results back and a bunch of other 00:25.950 --> 00:31.710 things that we'll be able to combine and use just as other tools in our arsenal or or weapons rather 00:32.010 --> 00:33.100 in our arsenal. 00:33.480 --> 00:39.720 So before we do that though I want to start by just adding a little bit more data to the books that 00:39.720 --> 00:41.270 we're currently working with. 00:41.310 --> 00:43.530 Basically I want to have a bit more variety. 00:43.710 --> 00:48.570 So I'd like to insert three new books and they look like this. 00:48.570 --> 00:54.220 So we have one here 10 percent happier by Dan Harris release in 2014. 00:54.330 --> 00:58.650 We have 29 in stock and it's 256 pages long. 00:58.650 --> 01:04.500 You'll see why we have said why we're inserting not just a couple of videos but there is a reason we're 01:04.500 --> 01:07.190 going to come back to it and then we have a fake book. 01:07.200 --> 01:11.310 So just imagine that we're testing our system or something and we want to make sure it works or we have 01:11.310 --> 01:16.440 fake underscore book and then that's written by Frida Harris in 2001. 01:16.650 --> 01:20.060 287 copies in stock 428 pages. 01:20.370 --> 01:26.150 And then this is actually one so I haven't read either of these but this is one I just finished. 01:26.460 --> 01:29.230 And that's one of the reasons I added it and there's another one though. 01:29.520 --> 01:30.120 It's really good. 01:30.120 --> 01:35.370 By the way if you're looking for a book called Lincoln in the bardo by George Saunders released just 01:35.370 --> 01:39.350 this year and we have a thousand copies in stock because it's brand new. 01:39.420 --> 01:42.030 So we haven't sold any or we haven't sold many yet. 01:42.060 --> 01:45.170 Or maybe we're anticipating a big flood of sales. 01:45.270 --> 01:47.370 And it's 367 pages. 01:47.430 --> 01:52.770 So either type it up or copy and pasted in the code is available along with this video and we're going 01:52.770 --> 01:58.830 to just copy and run over here make sure that we're doing let's make sure we're working with the correct 01:58.830 --> 02:01.130 database. 02:01.130 --> 02:01.540 All right. 02:01.560 --> 02:02.810 And bookshop. 02:02.810 --> 02:06.050 And we'll just paste that in in certain books. 02:06.050 --> 02:06.910 Blah blah blah blah blah. 02:06.950 --> 02:08.820 We don't need to go over everything. 02:09.350 --> 02:10.010 All right. 02:10.010 --> 02:11.780 So we get three rows affected. 02:11.840 --> 02:16.270 Let's do a select title from books. 02:16.280 --> 02:17.780 Just make sure that we have those in there. 02:17.780 --> 02:19.160 Here we go. 02:19.280 --> 02:22.070 We had to consider the lobster in the last section. 02:22.070 --> 02:25.770 Now we have 10 percent happier Facebook and LinkedIn in the Barta. 02:26.150 --> 02:26.440 All right. 02:26.450 --> 02:27.940 So that's all I want to do here. 02:27.950 --> 02:31.850 I highly recommend that you go and do this if you want to follow along. 02:31.940 --> 02:34.520 It will make the exercises much easier. 02:34.610 --> 02:39.200 It will make them possible in the first place and you'll be able to type the code that I type on your 02:39.200 --> 02:39.380 own. 02:39.380 --> 02:40.920 So I highly recommend that you do it. 02:41.360 --> 02:46.940 But I guess you could just watch if you want to do so without further ado let's get on to the new stuff.