```
table: users
+----+-------+
| id | name  |
+----+-------+
|  1 | alpha |
|  2 | beta  |
|  3 | gamma |
+----+-------+

table: address
+----+---------+------+--------------+
| id | user_id | type |   address    |
+----+---------+------+--------------+
|  1 |       1 | PRA  | welcome      |
|  2 |       1 | COA  | to the hotel |
|  3 |       2 | PRA  | california   |
+----+---------+------+--------------+

```

I understand the result of this query:

```
select u.*, a.*
from ccr.SJ_TEMP_USERS u
LEFT JOIN SJ_TEMP_ADDRESS a
on u.id = a.USER_ID
WHERE a.id IS NULL;
+----+-------+--------+---------+--------+---------+
| ID | NAME  |  ID_1  | USER_ID |  TYPE  | ADDRESS |
+----+-------+--------+---------+--------+---------+
|  3 | gamma | (null) | (null)  | (null) | (null)  |
+----+-------+--------+---------+--------+---------+

```

But I don't understand the result of this query.

```
select u.*, a.*
from ccr.SJ_TEMP_USERS u
LEFT JOIN SJ_TEMP_ADDRESS a
on u.id = a.USER_ID
and a.type = 'COA'
WHERE a.id IS NULL;

+----+-------+--------+---------+--------+---------+
| ID | NAME  |  ID_1  | USER_ID |  TYPE  | ADDRESS |
+----+-------+--------+---------+--------+---------+
|  3 | gamma | (null) | (null)  | (null) | (null)  |
|  2 | beta  | (null) | (null)  | (null) | (null)  |
+----+-------+--------+---------+--------+---------+

```

Please help me understand why do I get the row with 'beta' in the second query.
(I'm using Oracle SQL Developer).

Note that the row with 'alpha' does not appear if I put the condition `a.type = 'PRA'` instead of `a.type = 'COA'`