I have two tables in my SQL database:

Table 1: `Person`:

| Application | NoPerson | Name | Lastname | Salary | DateofBirth |
| --- | --- | --- | --- | --- | --- |
| 01 | 01 | name1 | lastname1 | 2000 | 1990-03-03 |
| 01 | 02 | name2 | lastname2 | NULL | 2010-01-01 |
| 02 | 01 | name1 | lastname1 | 2000 | 1993-03-03 |
| 02 | 02 | name2 | lastname2 | NULL | 2012-01-01 |

Table 2 : `EducationInfo`:

| Application | NoPerson | schoolgrade | school | goals |
| --- | --- | --- | --- | --- |
| 01 | 02 | 8. grade | St. Luis | Be Engineer |
| 02 | 02 | 3. grade | norcross | Be Professor |

I need to make a query that returns something like this: If the person is an adult, then show in column occupation his salary. And if it is a child, then show in same column the school grade.

Like this:

![enter image description here](https://i.stack.imgur.com/T2LiN.png)