Đã hoàn thành

Need a sqlite query to calculate time between rows

I need a sqlite query built to calculate the sum of time for a specific data element on a specified Date. Here is the table layout:

Runner: Action: Start-Time:

1 Walking 2017-08-01 12:00

1 Jogging 2017-08-01 12:30

1 Running 2017-08-01 13:15

1 Walking 2017-08-01 14:00

1 Jogging 2017-08-01 15:00

1 Running 2017-08-01 15:30

1 Walking 2017-08-01 16:00

1 Walking 2017-08-02 14:00

1 Jogging 2017-08-02 15:00

1 Running 2017-08-02 15:30

1 Walking 2017-08-02 16:00

The query should return the total running time for 2017-08-01. I need the function to look like this:

public long getTotalActionTime(String date, String runner, String action){

//sqlite query here

return totalActionTime;

}

The Start-Time is the stop time for the previous row. The last row time is calculated by calculating the difference between the Current Time and Start-Time

Kĩ năng: Java, SQLite

Xem nhiều hơn: sql server calculate difference between two rows, sql calculate date difference between two rows, sql datediff multiple rows, sql calculate difference between current and previous rows, sql calculate date difference between two columns, sql query to find difference between two consecutive rows, sql compare two rows of data for differences, how to get the difference between two rows in sql server, I need an Android app. I would like it designed and built. Hello My name is jitendra Parmar Mail I\ d - jitendraindia 2810 @gmai, i need a website built, I need a project to calculate BMI by given height and weight., i need sum indonesian language translation email, i need a website built in saskatoon, i need a website built for my business, i need a website built for me, i need a website built, this is a big data entry work for all freelancer no need any experience i need 50 workers for my work so please bid my project t, i need an android app i would like it designed and built, i need an android app i would like it designed and built quero desenvolver um aplicativo sobre financas que controle gastos e et, i need an android app i already have a design for it i just need it to be built gps service for taxi

Về Bên Thuê:
( 5 nhận xét ) Glen Rose, United States

ID dự án: #15042737

Được trao cho:

liangjongai

Hi! I'm interesting your project very well. i mastering java and SQLite. And also I have many experience and good skill about web and android development. Let's go ahead with me Stay tuned, I'm still working on this Thêm

$25 USD trong 1 ngày
(71 Đánh Giá)
5.4

2 freelancer đang chào giá trung bình $25 cho công việc này

imagicaworld

Hello Relevant Skills and Experience please have a look at our portfolio link:- [login to view URL] Proposed Milestones $25 USD - D Stay tuned, I'm Thêm

$25 USD trong 1 ngày
(1 Nhận xét)
2.4