In outer joins, the ON clause determines filtering and

the WHERE clause determines matching.

The ON clause uses three-valued logic and the WHERE

clause uses two-valued logic

The ON clause uses two-valued logic and the

WHERE clause uses three-valued logic.

In outer joins, the ON clause determines

matching and the WHERE clause determines filtering

FROM –>WHERE–>GROUP BY–>HAVING–>SELECT–>ORDER BY;

SELECT –>ORDER BY–>FROM –>WHERE

–>GROUP BY –>HAVING

FROM–>WHERE–>GROUP

BY–>HAVING –>ORDER BY–>SELECT;

SELECT–>FROM–>WHERE–>GROUP

BY–>HAVING–>ORDER BY;

ІР

UDР

ТСР

АRР

Null values in primary key fields;

Determinants;

Functional dependencies

Repeating groups;

4

3

0

1

7

Query will fail;

The first row;

Count of the rows in table Users;

The query will fail.

1

The first column;

The query will return 1 as many times  as many rows the table has;