WHERE

The WHERE clause is used to filter records based on a condition. The following SQL statement will return a table that only contains rows where the "StartingMedianSalary" is greater than 60000.

SELECT Major, StartingMedianSalary FROM Degrees WHERE StartingMedianSalary > 60000

You can use the following operators for the comparison.

Operator	Description
=	Equal
<>	Not equal.
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal