Closed

Write a SQLite Query

We utilize Spiceworks Helpdesk as a ticketing system. I need a SQL Query to see how many business hours it takes to close a ticket with the following requirements:

· Only count hours between 8-5 on Monday – Friday

· If a ticket is created and closed on the same weekend, then the result is 0

· If a ticket is created on the weekend, and resolved on Monday, then the clock begins counting on 8 AM Monday

· If a ticket is created on a weekday (Tuesday), and closed the next day (Wednesday), stop counting at 5 PM on Tuesday, and begin the clock again on 8 AM Wednesday

· If a ticket is created during business hours (3 PM), and closed after business hours (6 PM), then the result would be where the clock last stopped. (2 Hours total)

I can provide samples if you are interested in the project and have SQLite experience.

Skills: SQLite

See more: query sqlite json, xpath query sqlite, query sqlite zxing, write query update mysql, write mysql query

About the Employer:
( 3 reviews ) Fort Jennings, United States

Project ID: #14417131

21 freelancers are bidding on average $141 for this job

mahmoudgamal008

I have more than 5 years of experience working with SQL, SQlite, and sql programming. Relevant Skills and Experience I have more than 1800 answers in Stackoverflow(Q&A Site) writing SQL queries: http://stackoverflow. More

$150 USD in 1 day
(2 Reviews)
3.3
axiomswb

we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience SQL,MySQL,php, DBA, Data processing Proposed Milestones $100 More

$100 USD in 2 days
(1 Review)
1.0
BeshoyMousaKhair

. Relevant Skills and Experience . Proposed Milestones $150 USD - .

$150 USD in 3 days
(1 Review)
1.2
XpertCoolDev777

Finding TALENTED, DEDICATED, RELIABLE developer? That's me. :) Having gone through your job description, I am sure that I’m the one that you are looking for. The highest project quality, exact time frame, best rela More

$155 USD in 3 days
(0 Reviews)
0.0
kashivw

Done different projects in SQLLite (DICOM database). Doing one right now Relevant Skills and Experience Veteran (15+ years) database developer with specific expertise in SQL Server (v4.5 thru 16), Oracle (v6 thru 12c) More

$100 USD in 3 days
(0 Reviews)
0.0
jmarlonhj

I have eight years of experience working with SQL in complex queries for commercial, industrial and service companies. My queries are often used for decision-making Relevant Skills and Experience Eight years of experi More

$100 USD in 1 day
(0 Reviews)
0.0
khushbuvasoya237

A proposal has not yet been provided

$160 USD in 2 days
(0 Reviews)
0.0
man2002ua

SQL experience 15 years, SQLite - 5 years. Main work related to writing SQL queries more complex than this

$111 USD in 1 day
(0 Reviews)
0.0
vikasmandowara

I have 11 yrs of working experience in sqlite. I believe my expertise makes me the perfect match for your requirement. Looking forward to hearing from you

$55 USD in 3 days
(0 Reviews)
0.0
pramsweety

Dear, Thank you for posting a job on my favorite technology SQLite. I have been working with SQL queries for the past 5 years in ERP, Big Data and Data warehousing environment. I have been developing and coding SQ More

$244 USD in 3 days
(0 Reviews)
0.0
AndrewChenshx

Hi,I need more information: 1)If a ticket is open at 9 AM on Monday, Tuesday is public holiday, and the ticket is then closed at 9AM on Wednesday , then the result is 9 hours or 18 hours? 2)should the calculation be a More

$100 USD in 3 days
(0 Reviews)
0.0
neerajagrawal201

Hi, We are serving in the field of Website & Software Design, HTML, CSS, Java, PHP, C#, javascript, bootstrap, angular.js, .NET, SQL, Biometrics, Android native/hybrid, since 2015. We also started providing service in More

$99 USD in 3 days
(0 Reviews)
0.0
naveenraj93

I am an ETL tester, my work is to write Complex query to replicate the scenario done by ETL tools like Abinitio, Informatica Relevant Skills and Experience Able to write complex query and know VBA, javascript so th More

$100 USD in 2 days
(0 Reviews)
0.0
c0909h1179

Hi, I’m very interested in your project. I have a few years working on SQL. So please tell me if you are interested. Thanks

$277 USD in 1 day
(0 Reviews)
0.0
ske777

Greetings, I am experienced database designer and SQL specialist so can help you. Please invite me to chat to discuss concrete details of the job. Regards, Konstantin

$140 USD in 3 days
(0 Reviews)
0.0
flynnser

I am an IT graduate with lots of experience in writing SQL queries and ensuring that they work well and efficiently Relevant Skills and Experience MySQL SQL PHP Proposed Milestones $155 USD - Write SQL query based on More

$155 USD in 2 days
(0 Reviews)
0.0
poojamishra13

Hello sir, i would like to build this queries. Thanks

$166 USD in 7 days
(0 Reviews)
0.0
ProgramersGroup

hello sir I can do it less then this cost.

$99 USD in 3 days
(0 Reviews)
0.0
websicon

Hello sir/mam we will build query as per your requirement let's have chat to discuss thank you

$111 USD in 3 days
(0 Reviews)
0.0
amit0423

Hi, i'll definitely help you in creating the query to see how many business hours it takes to close a ticket with all your requirements. I have worked on SQLite and also made database in SQLite only. List of my sk More

$222 USD in 3 days
(0 Reviews)
0.0