SQL query to get Primary Instructor from Course level in Fusion HCM

Summary:

Recently we received a requirement from one of our customers to fetch Primary Instructor from Course level. After some R&D we were able to retrieve the required deatils from following sql

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications
25B (11.13.25.04.0)

Code Snippet (add any code snippets that support your topic, if applicable):

select c.display_name course_primary_instructor
from
wlf_li_courses_f a,
wlf_instructor_resources b,
per_person_names_f c
where 1 = 1
and a.dflt_facilitator_id = b.instructor_id
and b.person_id = c.person_id
and b.learning_item_id = <course_learning_item_id>