Петр

update tableName set price1= price1 + 300, price2= price2 + 300

select g.name, st.date, st.value from group g
inner join (select group_id, max(date) md from stat group by group_id) s on s.group_id = g.id
inner join stat st on st.group_id = g.id and st.date = s.md

Insert into tbl2 (name, id, maxtime, sumtime, timecount) 
select tbl1.name, tbl1.id, max(tbl1.time), sum(tbl1.time), count(1) from tbl1 group by tbl1.name, tbl1.id

select mngrs.manager_id from
(select mn.chief_id, cl.manager_id, count(1) cn
  from claim cl
inner join manager mn on (mn.id = cl.manager_id) and (mn.chief_id is not null)
group by mn.chief_id, cl.manager_id) mngrs
inner join 
(select cl.manager_id chiefid, count(1) cn
  from claim cl
inner join manager mn on (mn.id = cl.manager_id) and (mn.chief_id is null)
group by cl.manager_id) chiefs on chiefs.chiefid = mngrs.chief_id
where mngrs.cn > chiefs.cn