I have two tables like this
Table 1 : animal

```
Country  Lion Tiger State
india     4      5   Madhya Pradesh
india     10     2   Utrakhand
Russia    0      10  Primorsky krai
Russia    1      20  Khabarovsk Krai

```

and Table 2: Project\_Tiger

```
Country  No
India    10
Russia   5

```

I have created inumerable class like this

```
public animal animal {get;set;};
public project_tiger project_tiger {get;set;};

```

now I want to show result something like this in view

```
Country  NO  lion   tiger
india    10   14     7
Russia   5    1      30

```

here lion and tiger is sum of both the record in table 1 
10+4= 15, 5+2 =7, for india and same for russia

now I am lacking of knowledge how to query these data as sum from database using linq and how to show this in razor view

I can write query in sql like this but can't translate it to linq

```
select animal.country, No,  sum(lion), sum(tiger) from animal
       inner join project_tiger ON animal.country equals project_tiger.country

```

Any help regarding this will be appreciated.