select co.title, a.course_id, a.cnt_checkins, b.cnt_total, round(a.cnt_checkins/b.cnt_total,3) as ratiofrom ( se