Skip to content

Instantly share code, notes, and snippets.

@anderson-mota
Last active August 24, 2018 02:02
Show Gist options
  • Save anderson-mota/ad831298086546142cfd6d32b3cdfc90 to your computer and use it in GitHub Desktop.
Save anderson-mota/ad831298086546142cfd6d32b3cdfc90 to your computer and use it in GitHub Desktop.
SELECT A.DATA, COUNT(A.DATA) AS QTD FROM ACESSOS AS A GROUP BY A.DATA;
SELECT CONCAT(MONTH(A.DATA), '-', YEAR(A.DATA)) AS MES_DO_ANO, COUNT(A.DATA) AS QTD FROM ACESSOS AS A GROUP BY MONTH(A.DATA), YEAR(A.DATA);
SELECT GETDATE(YEAR, A.DATA), COUNT(A.DATA) AS QTD FROM ACESSOS AS A GROUP BY GETDATE(YEAR, A.DATA);
SELECT C.REGIAO, COUNT(C.REGIAO) AS QTD FROM CLIENTES AS C GROUP BY C.REGIAR;
SELECT C.ID_PLANO, COUNT(C.ID_PLANO) AS QTD FROM CLIENTES AS C GROUP BY C.ID_PLANO ORDER BY QTD DESC;
SELECT C.TIPO, COUNT(C.TIPO) AS QTD FROM CLIENTES AS C GROUP BY C.TIPO ORDER BY QTD DESC;
SELECT A.OPCAO_MENU, COUNT(A.OPCAO_MENU) AS QTD FROM ACESSOS AS A GROUP BY A.OPCAO_MENU;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment