SELECT COUNT (*) as ENTER, TRUNC (operation_time, 'MM')
	FROM statistic_journal
   WHERE user_id = 10000006 AND dtype = 'authentication'
GROUP BY TRUNC (operation_time, 'MM')
ORDER BY TRUNC (operation_time, 'MM')

SELECT *
FROM (select * from USER_ENTER) x
PIVOT
(USER_ID 
FOR USER_ID 
IN('10000006','10000007')
) 

SELECT *
  FROM USER_ENTER PIVOT (SUM (ENTER) FOR USER_ID IN ('10000001', '10000005', '10000006'));

CREATE VIEW USER_ENTER
(
	OPERATION_ID,
	USER_ID,
	ENTER,
	MONTH
)
AS
	  SELECT MIN (OPERATION_ID),
			 USER_ID,
			 COUNT (*) AS ENTER,
			 MIN (operation_time)
		FROM statistic_journal
	   WHERE dtype = 'authentication'
	GROUP BY USER_ID, TRUNC (operation_time, 'MM')
	ORDER BY USER_ID, TRUNC (operation_time, 'MM');

select UserID from t 
group by t.UserID having min(add_months(Month,(Enetr-1)))=min(Mn)
and max(Month)=to_date('01/12/2016','dd/mm/yyyy');