How to get referral candidates details using BIP report

Hi Team,

Could anyone give me the sql query for referral candidates details.

The report must contain

1. Candidate Number
2. Candidate Name
3. Candidate added into the system date.
4. Candidate Source tracking - Referral, Candidates created manually, candidates manually added to the requisition if the original source of adding is referral
5. Referrer person number
6. referrer person name
7. hired requisition number
8. offered date
9. candidate person number
10. candidate hired date

Regards,

Sneha Sarkar