I will call it back again with the lecture.
And in this lecture we go ahead and look at a quick example on.
So query.
All right.
So this is going to be a quick one guys.
Because in the previous lecture we were able to do an we did something on this.
Now let's go ahead and remove this.
So now I'm going to select a from my employees table.
And then we're going to select employees table.
So we're going to say go ahead and select our all from the employees and go ahead on that.
Check it out.
So this is our employees table right here.
And we're going to select our employees who do not have the CGP.
So we want to check George Steve.
And these people have a 0.00.
And this is what we're going to target.
Now let's go ahead and now say select.
So while I'm saying select CGP And uh, we're going to select that, uh, from employees.
And uh, we're going to give our react class.
So let's go ahead and give our react class.
And I'm going to say we have a C GPA is equal to 0.01 plus semicolon at the end.
And run this and check it out.
So we select from employees where CGP is equal to 0.0.
And you can see we have three of them right in here.
So if this is uh maybe something that repeats, you can do add something like um distinct into here.
But we don't just want that because we have three employees that have, uh, the GPA equals 0.0.
And this is what we want to focus on.
Now we go ahead and uh, make this a subquery.
And by creating the name so go to display the names of this uh employees.
So go ahead and say select uh first underscore name.
All right.
I'm not going to select that uh from employees.
And then we got all the way across.
So for me we are the CGP.
Okay.
That is our CGP.
And then so this keyword we now get in this we have the CGP is equal to the 0.0.
Okay.
So we'll go ahead and run this code and check it out.
So the first name is George Steve and Amanda.
These are the people who have the cGPA equal to 0.0.
All right.
So go ahead and check it out.
So this is going to just be a quick one to show a subquery inside another query.
So this is a subquery.
And we use that to display the names of employees that have the cGPA equal to 0.0.
So pull it down and practice with it.
And if you have any questions go ahead and use the question and answer section.
And I'm going to get back to you as soon as possible.
Thank you so much.
And I'm going to see you in the next video lecture.