Query to find a Concurrent Request Submitted by Users and its Count

Query:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RRRR HH24:MI:SS';
SELECT
user_name,
request_date,
count(*)
FROM
fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcp,
fnd_responsibility_tl fr,
fnd_user fu
WHERE
fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id
and fcr.responsibility_id = fr.responsibility_id
and fcr.requested_by = fu.user_id
and fr.language='US'
and user_concurrent_program_name='&Program_name'
group by user_name, request_date
order by request_date desc;

Other Query:

select user_name , req_date, count(*)
from(
SELECT
user_name,
to_char( request_date, 'DD-MON-RRRR') req_date
FROM
fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcp,
fnd_responsibility_tl fr,
fnd_user fu
WHERE
fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id
and fcr.responsibility_id = fr.responsibility_id
and fcr.requested_by = fu.user_id
and fr.language='US'
and request_date > sysdate -8
and user_concurrent_program_name like '&Program_name'
group by user_name, request_date
order by request_date desc)
group by user_name, req_date;