package track.repository; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import track.model.App; import track.model.MeasuresTrackNew; import java.math.BigInteger; import java.util.List; public interface MeasureRepository extends JpaRepository<MeasuresTrackNew, Long> { @Query(value = "select sum(click_num) from measures_track_new where appid in ?1 and ds <= ?2 and ds >= ?3", nativeQuery = true) Double findByApp(List<String> appid, String endDate, String startDate); }