MeasureRepository.java

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);
}