I have the following two queries:

Code:
SELECT SUBSTR(USER_ID,4,3),		CHAR(',',1),
       DATE_BUSINESS,              	CHAR(',',1),
       SUBSTR(USER_ID,7,1),        	CHAR(',',1),
       SUBSTR(LOG_DATA,1,17),      	CHAR(',',1)
 FROM  JRNL
 WHERE ( SUBSTR(USER_ID,1,4) IN ('XXXX','XXXX') )
   AND LOG_CODE = 343
   AND ( DATE_BUSINESS  BETWEEN '2015-01-02'
                            AND '2016-11-17')
   AND ( SUBSTR(LOG_DATA,14,2) = SUBSTR(LOG_DATA,31,2))
   AND ((SUBSTR(LOG_DATA,14,2) BETWEEN '13' AND '50') OR
        (SUBSTR(LOG_DATA,14,2) > 62 ))
   AND   SUBSTR(LOG_DATA,18,17) = ' '
ORDER BY
       SUBSTR(USER_ID,4,3),
       DATE_BUSINESS
Code:
SELECT
       SUBSTR(USER_ID,4,3) ,          	CHAR(',',1),
       DIGITS(YEAR(DATE_BUSINESS)) ,    CHAR(',',1),
       DIGITS(MONTH(DATE_BUSINESS)),    CHAR(',',1),
       DIGITS(COUNT(*))
 FROM  JRNL
 WHERE ( SUBSTR(USER_ID,1,4) IN ('XXXX','XXXX') )
   AND LOG_CODE = 343
   AND ( DATE_BUSINESS  BETWEEN '2015-01-02'
                            AND '2016-11-17')
   AND ( SUBSTR(LOG_DATA,14,2) = SUBSTR(LOG_DATA,31,2))
   AND ((SUBSTR(LOG_DATA,14,2) BETWEEN '13' AND '50') OR
        (SUBSTR(LOG_DATA,14,2) > 62 ))
   AND   SUBSTR(LOG_DATA,18,17) = ' '
GROUP BY 
	SUBSTR(USER_ID,4,3),
        YEAR(DATE_BUSINESS),
        MONTH(DATE_BUSINESS)

Partial output from query #1

Code:
N14,2015-02-09,S,PXXXX-XXXXX-XXXXX,
N14,2015-02-13,V,DXXXX-XXXXX-XXXXX,
N15,2015-05-04,I,HXXXX-XXXXX-XXXXX,
N15,2016-08-05,X,FXXXX-XXXXX-XXXXX,
N15,2016-08-08,M,LXXXX-XXXXX-XXXXX,
N24,2015-06-22,E,GXXXX-XXXXX-XXXXX,
N24,2015-06-26,E,DXXXX-XXXXX-XXXXX,
N24,2015-06-30,E,KXXXX-XXXXX-XXXXX,

Partial output from query #2

Code:
N14,0000002015,0000000002,0000000002
N15,0000002015,0000000005,0000000001
N15,0000002016,0000000008,0000000002
N24,0000002015,0000000006,0000000003

How can I "merge" the queries to just have one output that looks the same as output #1 plus one additional column that contains the monthly total by the 1st column (basically add the last column from output #2). So, the output looks something like:

Code:
N14,2015-02-09,S,PXXXX-XXXXX-XXXXX,
N14,2015-02-13,V,DXXXX-XXXXX-XXXXX,
				  ,2
N15,2015-05-04,I,HXXXX-XXXXX-XXXXX,
				  ,1
N15,2016-08-05,X,FXXXX-XXXXX-XXXXX,
N15,2016-08-08,M,LXXXX-XXXXX-XXXXX,
				  ,2
N24,2015-06-22,E,GXXXX-XXXXX-XXXXX,
N24,2015-06-26,E,DXXXX-XXXXX-XXXXX,
N24,2015-06-30,E,KXXXX-XXXXX-XXXXX,
				  ,3
In this example:
N14 has 2 records for Feb 2015
N15 has 1 record for May 2015 and 2 records for Aug 2016
N24 has 3 records for June 2015


Thank you in advance!