where clause in SQL

The SELECT statement returns all rows from one or more columns in a table. To select rows that satisfy a specified condition, you use a WHERE clause.
The syntax of the SQL WHERE clause is as follows:
```
SELECT select_list
FROM table_name
WHERE condition
ORDER BY sort_expression
```
The WHERE clause appears right after the FROM clause of the SELECT statement.  The WHERE clause uses the condition to filter the rows returned from the SELECT clause.
The condition must evaluate to true, false, or unknown. It can be a boolean expression or a combination of boolean expressions using the AND and OR operators.
The query returns only rows that satisfy the condition in the WHERE clause. In other words, only rows that cause the condition evaluates to true will be included in the result set.
SQL evaluates the WHERE clause after the FROM clause and before the SELECT and ORDER BY clause:
If you use column aliases in the SELECT clause, you cannot use them in the WHERE clause.
Besides the SELECT statement, you can use the WHERE clause in the UPDATE and DELETE statement to specify rows to be updated or deleted.
To form the condition in the WHERE clause, you use comparison and logical operators.
```
SELECT
	last_name,
	first_name
FROM
	customer
WHERE
	first_name = 'Jamie';
```
Home