I am trying to write a select statement gathering one row for each name. Expected output is hence: 

Name=Al, Salary=30, Bonus=10

Table\_1

```
Name   Salary
Al     10
Al     20

```

Table\_2

```
Name  Bonus
Al    5
Al    5

```

How do I write that?
I try to:

```
Select t1.Name, SUM(t1.Salary), SUM(t2.Bonus) FROM table_1 t1
LEFT JOIN table_2 t2 
ON t1.Name=t2.Name
Group By 1

```

I get bonus 20 instead of 10 as bonus. That is probably because there are two rows in t1 from which the bonus is summed up. How can I modify my function in order to get the correct bonus?