== Taking a Quiz

==== Actors: **Registered User (USER)**

**1.** Load Quiz for a Lesson.

{{{#!sql
SELECT quiz_id, total_points, passing_score
FROM quiz
WHERE lesson_id = :lessonId;


}}}


**2.** Store Quiz Attempt.


{{{#!sql
INSERT INTO quiz_attempt (score, attempt_date, user_id, quiz_id)
VALUES (:score, CURRENT_DATE, :userId, :quizId);

}}}

**3.** Check Quiz Result.


{{{#!sql
SELECT CASE
     WHEN :score >= passing_score THEN 'PASSED'
     ELSE 'FAILED'
     END AS result
FROM quiz
WHERE quiz_id = :quizId;

}}}