public interface MemberRepository extends JpaRepository<SpringMember, Integer> {

    SpringMember findBySeqAndName(int seq, String name);

    List<SpringMember> findTop3ByNameLike(String name);

    SpringMember readBySeq(int seq);

    SpringMember readByName(String name);

    SpringMember queryBySeq(int seq);

    long countByNameLike(String name);

    long countByName(String name);

    @Query(value = "SELECT seq, name FROM SPRING_DATA_MEMBER", nativeQuery = true)
    List<SpringMember> nativeQuery();

    @Query(value = "SELECT seq, name FROM SPRING_DATA_MEMBER WHERE name = :name", nativeQuery = true)
    SpringMember nativeQueryByName(@Param(value = "name") String name);

    @Async
    CompletableFuture<List<SpringMember>> readAllBy();
}