00:01
So, for this problem, we know that we start off with the statement, select first name, last name, salary from employees.
00:09
So, that means that if we have our table labeled employees, with the first, i'll abbreviate that as fn, ln, and s for salary, you know, we have, well, i'm lucas finney, salary is something, and then we would have a whole bunch of rows.
00:36
We would have the first name, last name, and salary for all of the employees, all of the individuals in the employee table.
00:43
But we're not interested in all of the employees, we just want to know about ed.
00:49
So, we have that there is somebody in our organization whose first name is ed, and we want to get their last name and their salary.
00:57
So, the way that we modify this, we add the restriction, the where clause.
01:09
The restriction is that we want a particular value in the first name column.
01:15
So, we would say where first name equals ed.
01:30
Now, i'll note that this will only get the individual whose first name is in our database as ed...