Generate SQL Query for time spent by each other user with the specified user

$12-30 SGD

Completed

Posted

over 6 years ago

$12-30 SGD

Paid on delivery

You will be given the a [login to view URL] for macaddress,timestamp,locationid of every single timestamp entry You will need to compute the timespent by every other user with the specified user There will be corner cases like if there is one record of timestamp you can assume that he/she stayed for 5mins that location. if the diff of the 2 timestamps > 5 mins you should take 5 mins of the end of the query time. There will be exact results that is calculated manually. We wish to use SQL to make it easier.

Microsoft SQL Server

MySQL

PHP

Software Architecture

SQL

Project ID: 15462534

About the project

2 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@olasheni

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Relevant Skills and Experience HTML CSS JavaScript PHP jQuery/AJAX SQL Laravel WordPress API Integration Shopify Integration Website Maintenance Proposed Milestones $27 SGD - Full Data Mine Integration Additional Services Offered $1 SGD - Free Further Consultancy Hi there! Am interested in working with you, are you also interested in working with me?

$27 SGD in 1 day