SELECT NAME_TABLE.USER, TO_CHAR(NAME_TABLE.LAST_LOGIN, 'DD/MM/YYYY') LAST_LOGIN, NAME_TABLE.SAILA, MAX(NAME_TABLE.INTENTS) INTENTS, NAME_TABLE.MAQ FROM OWNER.MY_TABLE_NAME NAME_TABLE
WHERE NAME_TABLE.LAST_LOGIN>=TO_DATE('22/02/2017' || ' 00:00:00', 'dd/mm/yyyy hh24:mi:ss') AND NAME_TABLE.LAST_LOGIN <= TO_DATE('22/02/2017' || ' 23:59:59', 'dd/mm/yyyy hh24:mi:ss')
GROUP BY NAME_TABLE.USER, TO_CHAR(NAME_TABLE.LAST_LOGIN,'DD/MM/YYYY'), NAME_TABLE.SAILA, NAME_TABLE.INTENTS, NAME_TABLE.MAQ ORDER BY NAME_TABLE.SAILA, NAME_TABLE.LAST_LOGIN DESC;

ORA-00979: not a GROUP BY expression

SELECT NAME_TABLE.USER, TO_CHAR(NAME_TABLE.LAST_LOGIN, 'DD/MM/YYYY') LAST_LOGIN, NAME_TABLE.SAILA,  (SELECT MAX(INTENTS) FROM OWNER.NAME_TABLE), NAME_TABLE.MAQ FROM OWNER.MY_TABLE_NAME NAME_TABLE
WHERE NAME_TABLE.LAST_LOGIN>=TO_DATE('22/02/2017' || ' 00:00:00', 'dd/mm/yyyy hh24:mi:ss') AND NAME_TABLE.LAST_LOGIN <= TO_DATE('22/02/2017' || ' 23:59:59', 'dd/mm/yyyy hh24:mi:ss')
GROUP BY NAME_TABLE.USER, TO_CHAR(NAME_TABLE.LAST_LOGIN,'DD/MM/YYYY'), NAME_TABLE.SAILA, NAME_TABLE.INTENTS, NAME_TABLE.MAQ ORDER BY NAME_TABLE.SAILA;

MAX(NAME_TABLE.INTENTS) INTENTS

(SELECT MAX(INTENTS) FROM OWNER.NAME_TABLE)