I have a table called `item_log` with this sample data

```
LOG_ID   | LOG_TYPE  | LOG_DATE
401      | R1        | 1-1-2018
401      | R2        | 1-2-2018
401      | R3        | 2-2-2018
401      | R1        | 2-3-2018
401      | R2        | 3-1-2018
402      | R1        | 1-1-2018
402      | R2        | 1-2-2018
402      | R3        | 2-2-2018
403      | R1        | 1-1-2018
403      | R2        | 1-2-2018
403      | R3        | 2-2-2018
404      | R1        | 1-1-2018
404      | R2        | 1-2-2018
404      | R3        | 2-2-2018
404      | R4        | 2-4-2018
404      | R5        | 5-2-2018

```

I need to show only the `LOG_ID` records that have a date occurring after the TYPE `R3`.

I am guessing it would be a subquery but I am a novice at doing them and new to oracle so any guidance would be appreciated.

Thank you in advance for the knowledge.

the results would show something like this:

```
LOG_ID   | TYPE  | LOG_DATE
401      | R3    | 2-2-2018
404      | R3    | 2-2-2018

```