@TransactionalpublicinterfaceSalesManLeaderRepositoryextendsJpaRepository<SalesManLeader,Long>{@Query(value="select email from sales_man_leader where id=(select leader from sales_man_leader where id=?1)",nativeQuery=true)StringfindLeaderByBussinessMan(LongbussinessMan);
@Query(value="select * from sales_man_leader where leader = (select id from sales_man_leader where email = ?1)",nativeQuery=true)List<SalesManLeader>findByEmail(Stringemail);@Query(value="select * from sales_man_leader where email = ?1",nativeQuery=true)SalesManLeaderfindOneByEmail(Stringemail);