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

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