INSERT INTO `mdl_gradeimporter_submissiontype` (`id`, `name`, `info`)
VALUES
	(1, 'Prova', 'Avaliação de alunos'),
	(2, 'Exercicio', 'Exercicio de alunos');

INSERT INTO `mdl_gradeimporter_submission` (`id`, `gradeimporter`, `type`, `gradebook`, `timecreated`, `timemodified`, `usermodified`, `name`, `info`, `position`, `visibility`)
VALUES
	(1, 1, 1, X'31', 0, 0, 0, 'P1', 'Prova aplicada no dia 14/12/19', 0, X'31'),
	(2, 1, 1, X'31', 0, 0, 0, 'P2', 'Prova aplicada no dia 17/12/19', 0, X'31'),
	(3, 1, 1, X'31', 0, 0, 0, 'P3', 'Prova aplicada no dia 18/12/19', 0, X'31'),
	(3, 1, 2, X'31', 0, 0, 0, 'E1', 'Prova aplicada no dia 14/12/19', 0, X'31'),
	(4, 1, 2, X'31', 0, 0, 0, 'E2', 'Prova aplicada no dia 17/12/19', 0, X'31');

INSERT INTO `mdl_gradeimporter_feedback` (`id`, `submissionid`, `studentid`, `grade`, `comment`, `fileid`, `usermodified`, `timecreated`, `timemodified`)
VALUES
 	(1, 1, 2, 7.00, 'Muito bem', 100, 0, 0, 0),
  (2, 2, 2, 8.00, 'Mais pra bom', 100, 0, 0, 0),
  (3, 3, 2, 5.00, 'Mais pra ruim', 100, 0, 0, 0),
 	(4, 4, 2, 6.00, 'Mais pra ruim', 100, 0, 0, 0),
  (5, 1, 2, 6.00, 'Mais pra ruim', 100, 0, 0, 0),
  (6, 2, 2, 5.00, 'Mais pra ruim', 100, 0, 0, 0);

 SELECT *
   FROM mdl_gradeimporter_feedback gf
   JOIN mdl_gradeimporter_submission gs
     ON gf.submissionid = gs.id
   JOIN mdl_gradeimporter_submissiontype gst
     ON gs.type = gst.id
	WHERE gf.studentid = ?