title: SQL: selecting data from a table that doesn't contain value from another table
body: <p>I have some tables:</p>
  
  <pre><code>CREATE TABLE `entidade_pessoa_avaliacao` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `idEntidade_pessoa` int(10) unsigned NOT NULL,
    `idSemana` int(10) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `idEscola_Matriculado_idSemana` (`idEntidade_pessoa`,`idSemana`),
    KEY `idEscola_Matriculado` (`idEntidade_pessoa`),
    KEY `idSemana` (`idSemana`),
    CONSTRAINT `FK_smsescola_escola_acao_smsescola_escola_matriculado` FOREIGN KEY (`idEntidade_pessoa`) REFERENCES `entidade_pessoa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `FK_smsescola_escola_matriculado_avaliacao_smsescola_semana` FOREIGN KEY (`idSemana`) REFERENCES `semana` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8;
  
  
  INSERT INTO `entidade_pessoa_avaliacao` (`id`, `idEntidade_pessoa`, `idSemana`) VALUES
      (1, 1, 1),
      (2, 2, 1),
      (3, 3, 1),
      (4, 1, 2),
      (5, 2, 2),
      (6, 3, 2);
  
  
  CREATE TABLE  `semana` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `nome_curto` varchar(250) NOT NULL,
    `inicio` date NOT NULL COMMENT,
    `termino` date NOT NULL COMMENT,
    `idDimensao` int(10) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    KEY `idDimensao` (`idDimensao`)
  ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
  
  
  INSERT INTO `semana` (`id`, `nome_curto`, `inicio`, `termino`) VALUES
      (1, 'Faltas', '2017-10-24', '2017-11-14'),
      (2, 'Tarefas','2017-11-07', '2017-11-14'),
      (3, 'Participacao','2017-11-07', '2017-11-14');
  </code></pre>
  
  <p>I need to figure out wich WEEK isn't in the student_avaliation table based on the date. For example, what should I do to know which week wasn't registered where week.end='14/11/2017'?</p>
  
  <p>I know that I have to use     NOT EXISTS    but I don't know how to do it.</p>
  
  <p>Can anyone help me?</p>