rapha.sql

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;