Given a 3 columns sql table (id, time (timestamp eg 2018-11-01 19:46:35), user_id) should get the arrival time of each day (first entry of day) the departure time (last entry), the average (monthly and yearly) arrival and departure time and the day's name eg Monday.
Since through the entry system a user pass lot of times every day there might be lot of records
eg for the user with ID 38
10/25/2018 5:52:26 PM
10/25/2018 4:00:54 PM
10/25/2018 3:53:15 PM
10/25/2018 10:01:48 AM
10/25/2018 9:06:41 AM
Bu iş için 15 freelancer ortalamada €15 teklif veriyor
Hi I am software engineer and full stack PHP developer your project is looking very interesting and I am looking forward to your message
Hello, my name is Vladimir and i am Web Developer from Serbia. I can help you with completing your project.
Hi there, I have gone through your project details and I am much confident to create the script responsible for calculating the arrival and departure time for your web application kindly have a chat with me so Daha Fazla
Dear Sir, I can do this task it's simple task , let me show you . we can do some test for make sure i can solved this task. Regards, DiO
Hi, Sir If you let me know your detailed requirement specification of your project, you may rest assured that your project will be finished with SMART UI design, POWERFUL UX and HIGH quality. I can work whole tim Daha Fazla
Hi there, I have gone through your requirements and its very straightforward job. O can start right a. Can we start a short chat over here to make the deal? Kind Regards