Quando adiciono o código a baixo na classe MedicoRepository

@Query(""" select m from Medico m where m.ativo = true and m.especialidade = :especialidade and m.id not in ( select c.medico.id from Consulta c where c.data = :data ) order by rand() limit 1 """) Medico escolherMedicoAleatorioLivreNaData(Especialidade especialidade, LocalDateTime data);

Acontece o seguinte erro:

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. 2023-11-05T23:14:28.239-03:00 ERROR 46898 --- [ restartedMain] o.s.boot.SpringApplication : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'consultaController': Unsatisfied dependency expressed through field 'agenda': Error creating bean with name 'agendaDeConsultasService': Unsatisfied dependency expressed through field 'medicoRepository': Error creating bean with name 'medicoRepository' defined in med.voll.API.repository.medico.MedicoRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract med.voll.API.domain.medico.Medico med.voll.API.repository.medico.MedicoRepository.escolherMedicoAleatorioLivreNaData(med.voll.API.domain.medico.Especialidade,java.time.LocalDateTime); Reason: Validation failed for query for method public abstract med.voll.API.domain.medico.Medico med.voll.API.repository.medico.MedicoRepository.escolherMedicoAleatorioLivreNaData(med.voll.API.domain.medico.Especialidade,java.time.LocalDateTime)