diff --git a/sql/schema.sql b/sql/schema.sql
index a3197e1..d245670 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -271,3 +271,6 @@
 -- UPDATE criterion
 -- SET	weight = Cast(max AS DOUBLE) / (SELECT Count(*)
 -- FROM   criterion);
+
+
+create view unmarked as select * from student where submission_id not in (select distinct submission_id from result)