Skip to content

Instantly share code, notes, and snippets.

@raphaeldealmeida
Created August 19, 2019 23:13
Show Gist options
  • Save raphaeldealmeida/1dd7a47e3201d9c728bdd1818e5e858f to your computer and use it in GitHub Desktop.
Save raphaeldealmeida/1dd7a47e3201d9c728bdd1818e5e858f to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment