SELECT per.first_name AS Имя, per.last_name AS Фамилия, SUM (CAST (con.salary AS int)) AS Зарплата_в_месяц, SUM (CAST (con.salary AS int))*12 AS Зарплата_в_год, (SUM (CAST (con.salary AS int))*4*(CAST(con.bonus_percent AS REAL))) AS Бонус_год, SUM (CAST (con.salary AS int))*0.13 AS НДФЛ_мес,SUM (CAST (con.salary AS int))*12*0.13 AS НДФЛ_год, SUM (CAST (con.salary AS int))*0.08 AS ПФР_мес,SUM (CAST (con.salary AS int))*12*0.08 AS ПФР_год, SUM (CAST (con.salary AS int))*0.062 AS Страх_взн_мес, SUM (CAST (con.salary AS int))*12*0.062 AS Страх_взн_год, Итог_мес, Итог_годFROM PUBLIC.his_contract AS con, PUBLIC.his_person AS per,(SELECT Имя, Фамилия, ("Зарплата_в_месяц"+"НДФЛ_мес"+"Страх_взн_мес"+"ПФР_мес") AS Итог_мес, ("Зарплата_в_год"+"Бонус_год"+"НДФЛ_год"+"ПФР_год"+"Страх_взн_год") AS Итог_годFROM PUBLIC.result) AS res WHERE con.person_id = per.id AND con.state = 'ACTUAL' AND per.first_name= res.Имя AND per.last_name= res.ФамилияGROUP BY per.first_name, per.last_name, con.bonus_percent, Итог_мес, Итог_год