Đang Thực Hiện

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 thêm: 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, i need a wordpress theme built, i need a android game app built, i need 1000 wordpress sites built, php script current date time, jsp mysql insert current date time display displaying, insert current date time mysql perl cgi, calculate time difference infopath date picker, calculate current date adobe pdf, javascript adobe form calculate current date, wordpress query post current date, bash script current date time, pdf fillable form calculate current date, acrobat calculate current date

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

Mã Dự Án: #15042737

Đã 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:- [url removed, login to view] Proposed Milestones $25 USD - D Stay tuned, I'm Thêm

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