Number of attempts by each learner are not showing

Hello,

I need to get the number of attempts that a learner did on a course. 

Example below:

Offering Title: JV Test 01/18_SP

Person number: 001670007

1st attempt - 50

2nd attempt - 95

3rd attempt - 87.5

 

I've used this query to check the attempt number but it didn't return any results.

SELECT 

papf.person_id

,event_cnt.LEARNING_ITEM_ID

,event_cnt.EVENT_ID

,event_cnt.ATTRIBUTION_ID

,event_cnt.event_attmpt

FROM

PER_ALL_PEOPLE_F PAPF

,wlf_li_content_f D

        ,(SELECT DISTINCT ev.LEARNING_ITEM_ID

                ,ev.EVENT_ID

                ,ev.ATTRIBUTION_ID

                ,count(ev.EVENT_ID) event_attmpt

        FROM WLF_EVENTS ev