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