Example plan: Selecting with a WHERE clause

- [Instructor] Okay, let's continue to work … with the staff table. … And this time, we're going to restrict the rows … so that we return only those rows … that have a salary greater than $75,000. … So for that we're going to need to add a where clause … to that select statement we had earlier. … So I'll type select, start, from staff. … And I'm going to add a where clause, … where salary is greater than 75 thousand. … And we'll execute this. … And we'll notice there are 717 rows that returned. … So that's good to know. … We'll keep that in mind. … Now, let's see what steps were actually taken … to execute that statement. … So I'm going to insert explain, … so then I can, this will just estimate the cost. … It's not actually going to execute it. … And we'll get a query plan. … I'll just expand this out a little bit. … And we'll notice, this is very similar … to what we saw before. … We have a sequence scan, and we're returning about 700 rows. … And the width is about 75. … So you'll notice, the exact count on the rows is off by two. …