Select ((Case When (Select C.Rashod_month From Mama AS A
Join Pig As B On A.Klichka_mama=B.Klichka_mama AND B.Klichka = 'Boris'
Join Korm As C On C.Korm_name = A.Korm_Name
Where A.Korm_Name='aves' ) Is null then 0 else
(Select C.Rashod_month From Mama AS A
Join Pig As B On A.Klichka_mama=B.Klichka_mama AND B.Klichka = 'Boris'
Join Korm As C On C.Korm_name = A.Korm_Name
Where A.Korm_Name='aves')end)
+
(Case When (Select C.Rashod_month From Papa AS A
Join Pig As B On A.Klichka_papa=B.Klichka_papa AND B.Klichka = 'Boris'
Join Korm As C On C.Korm_name = A.Korm_name
Where A.Korm_Name='aves') Is null then 0 else 
(Select C.Rashod_month From Papa AS A
Join Pig As B On A.Klichka_papa=B.Klichka_papa AND B.Klichka = 'Boris'
Join Korm As C On C.Korm_name = A.Korm_name
Where A.Korm_Name='aves' ) end) 
+
(Case When( Select C.Rashod_month From Pig AS A
Join Korm As C On C.Korm_name = A.Korm_name
Where A.Korm_Name='aves' AND A.Klichka = 'Boris')  Is null then 0 else 
( Select C.Rashod_month From Pig AS A
Join Korm As C On C.Korm_name = A.Korm_name
Where A.Korm_Name='aves' AND A.Klichka = 'Boris') end)) * ((YEAR('2012-01-11') - YEAR('2011-12-11'))* 12
 + MONTH('2012-01-11') - MONTH( '2011-12-11'))
As Rashod_korma_ALL

Select Pig.Klichka,Pribavka_weight_month,Pribavka_weight_month *  ((YEAR('2012-02-11') - YEAR('2011-12-11'))* 12
 + MONTH('2012-02-11') - MONTH( '2011-12-11')) As Sum_Prives,Pig.Korm_name, Korm.Rashod_month *  
 ((YEAR('2012-02-11') - YEAR('2011-12-11'))* 12
 + MONTH('2012-02-11') - MONTH( '2011-12-11')) As Sum_Rashod  From Pig,Korm
Where Pig.Svinarka = 'Lena' And Pig.Korm_name = Korm.Korm_name

Select Pig.Svinarka,(Select  CAST (Sum( Pig.Pribavka_weight_month*  
 ((YEAR('2012-02-11') - YEAR('2011-12-11'))* 12
 + MONTH('2012-02-11') - MONTH( '2011-12-11'))) As Float) As A  From Pig,Korm 
Where Pig.Svinarka = 'Lena')
/
(Select Cast (Sum(Korm.Rashod_month *  
 ((YEAR('2012-02-11') - YEAR('2011-12-11'))* 12
 + MONTH('2012-02-11') - MONTH( '2011-12-11'))) As Float) As Sum_Rashod  From Korm
 Join Pig On Pig.Korm_name_ID=Korm.Korm_name_ID
 Where Pig.Svinarka = 'Lena')
 As Koef From Pig  Where Pig.Svinarka = 'Lena' Group By Pig.Svinarka