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

$12-30 SGD

Slutfört

Publicerad

över sex år sedan

$12-30 SGD

Betalning vid leverans

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

Om projektet

2 anbud

Distansprojekt

Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@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 Om 1 dag