id  |       id_course  |  lesson_title
    1  |          3       |      Урок 1
    2  |          3       |      Урок 2
    3  |          3       |      Урок 3
    4  |          4       |      Урок 4
    5  |          4       |      Урок 5

id  |       id_lesson  |             email      |    date
  43  |          1       |     123@gmail.com      |    2018-07-09 13:17:05
  44  |          2       |     123@gmail.com      |    2018-07-09 13:18:05
  45  |          3       |     123@gmail.com      |    2018-07-09 13:19:05

function total_score($id){
    global $connection;
   $query = "SELECT l.id_course, h.email, MAX(h.date) FROM lesson l LEFT JOIN history h ON h.eid = l.id GROUP BY l.id_course, h.email HAVING SUM(h.eid IS NULL) = 0 WHERE l.id_course= '$id'";
    $res = mysqli_query($connection, $query);
    $total_score = array();
    while($row = mysqli_fetch_assoc($res)){
        $total_score[$row['date']] = $row;
    }
    return $total_score;
}

SELECT l.id_course, h.email, MAX(h.date)
FROM lesson l
LEFT JOIN history h ON h.id_lesson = l.id
GROUP BY l.id_course, h.email
HAVING SUM(h.id_lesson IS NULL) = 0