previsao.sql

select avg(valor) previsao_valor from (
   SELECT TOP (1000) avg(VALOR) valor
   FROM [onboard].[dbo].[RESUMO]
   where (EMPRESA_ID = 1)
     and (VALOR > 0)
     and (DAY_WEEK = 1)

   UNION
   SELECT TOP (1000) avg(VALOR) valor
   FROM [onboard].[dbo].[RESUMO]
   where (EMPRESA_ID = 1)
     and (VALOR > 0)
     and (DAY_WEEK = 1)
     and (ORDEM_SEMANA = 1)

   UNION
   SELECT TOP (1000) avg(VALOR) valor 
   FROM [onboard].[dbo].[RESUMO]
   where (EMPRESA_ID = 1)
     and (VALOR > 0)
     and (DAY_WEEK = 1)
     and (MES = 1)
) as medias