select a.coursename as category, (select coursename from cutech_course where c_id = c.subcat_course) as subcategory, c.* from cutech_course a right join cutech_coursemanagement c on a.c_id = c.cat_course where c.status = 1 and c.delete_status=0 and c.course_name='AWS%u2212;CWEngineering Examination' limit 1