WEBVTT 00:07.340 --> 00:09.230 I will call it back again with the lecture. 00:09.890 --> 00:14.270 And in this lecture we go ahead and look at a quick example on. 00:14.300 --> 00:16.340 So query. 00:16.370 --> 00:16.670 All right. 00:16.670 --> 00:18.050 So this is going to be a quick one guys. 00:18.050 --> 00:22.610 Because in the previous lecture we were able to do an we did something on this. 00:22.640 --> 00:24.680 Now let's go ahead and remove this. 00:24.680 --> 00:29.030 So now I'm going to select a from my employees table. 00:29.030 --> 00:32.660 And then we're going to select employees table. 00:32.780 --> 00:41.570 So we're going to say go ahead and select our all from the employees and go ahead on that. 00:41.570 --> 00:42.410 Check it out. 00:42.740 --> 00:44.990 So this is our employees table right here. 00:44.990 --> 00:49.250 And we're going to select our employees who do not have the CGP. 00:49.310 --> 00:51.590 So we want to check George Steve. 00:51.620 --> 00:54.110 And these people have a 0.00. 00:54.110 --> 00:56.330 And this is what we're going to target. 00:56.360 --> 01:00.980 Now let's go ahead and now say select. 01:03.500 --> 01:12.890 So while I'm saying select CGP And uh, we're going to select that, uh, from employees. 01:14.540 --> 01:18.560 And uh, we're going to give our react class. 01:18.560 --> 01:20.030 So let's go ahead and give our react class. 01:20.030 --> 01:28.040 And I'm going to say we have a C GPA is equal to 0.01 plus semicolon at the end. 01:28.580 --> 01:29.990 And run this and check it out. 01:29.990 --> 01:34.610 So we select from employees where CGP is equal to 0.0. 01:34.610 --> 01:36.590 And you can see we have three of them right in here. 01:36.740 --> 01:43.070 So if this is uh maybe something that repeats, you can do add something like um distinct into here. 01:43.070 --> 01:50.570 But we don't just want that because we have three employees that have, uh, the GPA equals 0.0. 01:50.570 --> 01:52.460 And this is what we want to focus on. 01:52.490 --> 01:56.480 Now we go ahead and uh, make this a subquery. 01:56.480 --> 02:02.360 And by creating the name so go to display the names of this uh employees. 02:02.360 --> 02:09.440 So go ahead and say select uh first underscore name. 02:09.470 --> 02:10.280 All right. 02:10.310 --> 02:15.260 I'm not going to select that uh from employees. 02:15.530 --> 02:17.690 And then we got all the way across. 02:17.690 --> 02:22.010 So for me we are the CGP. 02:24.680 --> 02:25.010 Okay. 02:25.040 --> 02:26.540 That is our CGP. 02:27.590 --> 02:36.200 And then so this keyword we now get in this we have the CGP is equal to the 0.0. 02:36.230 --> 02:36.680 Okay. 02:36.710 --> 02:39.650 So we'll go ahead and run this code and check it out. 02:39.680 --> 02:44.180 So the first name is George Steve and Amanda. 02:44.210 --> 02:47.570 These are the people who have the cGPA equal to 0.0. 02:47.600 --> 02:48.170 All right. 02:48.170 --> 02:49.910 So go ahead and check it out. 02:50.600 --> 02:55.790 So this is going to just be a quick one to show a subquery inside another query. 02:55.790 --> 02:57.260 So this is a subquery. 02:57.260 --> 03:03.320 And we use that to display the names of employees that have the cGPA equal to 0.0. 03:03.320 --> 03:04.820 So pull it down and practice with it. 03:04.820 --> 03:07.970 And if you have any questions go ahead and use the question and answer section. 03:07.970 --> 03:10.280 And I'm going to get back to you as soon as possible. 03:10.310 --> 03:11.210 Thank you so much. 03:11.210 --> 03:14.120 And I'm going to see you in the next video lecture.