How can we get data by join for example in my sql my query is select COUNT(UCA.user_id) from user_course_assignments AS UCA INNER JOIN Courses AS C ON C.id = UCA.course_id

Hello @Gaurav Tiwari, GoodData automatically joins tables when needed based on the context of your metric or insight. You can check the docs for count function based on your GoodData version: • GoodData Platform • GoodData Cloud/CN