--
-- Тестовые данные:
with
  t (id,pole1,pole2,pole3,pole4) as
    (
      select 1, 11, 33, 2013, 1 union all
      select 2,  9,  4, 2013, 2
    )
--
-- Основной запрос:
select distinct 
       sum(pole1) over() as total_sum_of_pole2,
       first_value(pole2) over(order by pole3 desc, pole4 desc) as last_value_of_pole2
  from t

--
-- Тестовые данные:
with
  t (id,pole1,pole2,pole3,pole4) as
    (
      select 1, 11, 33, 2013, 1 union all
      select 2,  9,  4, 2013, 2
    )
--
-- Основной запрос:
select distinct 
       sum(pole1) over() as total_sum_of_pole2,
       first_value(pole2) over(order by pole3 desc, pole4 desc) as last_value_of_pole1
  from t

--
-- Тестовые данные:
with
  t (id,pole1,pole2,pole3,pole4) as
    (
      select 1, 11, 33, 2013, 1 union all
      select 2,  9,  4, 2013, 2
    )
--
-- Основной запрос:
select distinct 
       sum(pole1) over() as total_sum_of_pole1,
       first_value(pole2) over(order by pole3 desc, pole4 desc) as last_value_of_pole2
  from t

--
-- Тестовые данные:
with
  t (id,pole1,pole2,pole3,pole4) as
    (
      select 1,1,5,2013,1 union all
      select 2,2,7,2013,1 union all
      select 3,4,5,2013,2 union all
      select 4,4,5,2013,2
    )
--
-- Основной запрос:
select distinct 
       sum(sum(pole1)) over() as total_sum_of_pole1,
       first_value(sum(pole2)) over(order by pole3 desc, pole4 desc) as last_value_of_pole2
  from t
 group by pole3, pole4