[[PageOutline]]

== Database ==

=== Find student who saved the evaluation but not submit yet ===
{{{
#!sql
SELECT * FROM users 
WHERE id IN 
    (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = EVENTID AND evaluator NOT IN 
        (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = EVENTID)
    );
}}}