Find Jobs
Hire Freelancers

Create a Mysql query

$10-30 USD

Cancelled
Posted over 6 years ago

$10-30 USD

Paid on delivery
I do have a database with a table as below: CREATE TABLE `error_monitoring` ( `id` int(11) NOT NULL, `error_monitoring_page` varchar(256) NOT NULL, `error_code` varchar(64) NOT NULL, `monitoring_country` varchar(64) DEFAULT NULL, `platform` varchar(64) NOT NULL, `total` int(64) NOT NULL, `visits` int(64) NOT NULL, `unique_visitors` int(64) NOT NULL, `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ) ENGINE=MyISAM DEFAULT CHARSET=latin1; In this table is stared data that comes from a .csv file. The .csv fila has only 5 columns: - date - error_monitoring_page - total - visits - unique visitors The rest of the information like country and platform is taken from the and error_code from the field "error_monitoring_page" in which this information is contained and then added into the corresponding field. In the .csv file the information comes as below example: 2017/03/13 03:00:00,us:es:website:track-transfer:moneytransfer-tab|C1620,16,3,3 2017/03/13 03:00:00,us:es:website:price-estimator:continue|PS9999,4,3,3 2017/03/13 03:00:00,us:es:website:send-money:register|C6003,0,0,0 2017/03/13 03:00:00,us:es:website:send-money:sendmoneylogin|C1131,0,0,0 2017/03/13 03:00:00,us:es:website:send-money:start|PS9999,3,1,1 2017/03/13 03:00:00,us:es:website:price-estimator:continue|C1053,0,0,0 2017/03/13 03:00:00,us:es:website:send-money:start|C5000,8,4,4 This field "us:es:website:track-transfer:moneytransfer-tab|C1620" is containing : error code : last 5 characters os the string. monitoring_country: first 2 characters of the string. and the platform: website The .csv file is received every hours some we have in the database data for every hour of the day for each error_monitoring_page. I need an MySql query that extracts and calculate the error codes that is exceeding for the total count of the day the Upper Control Limit. Said that: UCL = average+(2*standard deviation) For example: if total count of the current day for the error code C1620 is higher that the UCL the query should extract all the information of this error code: - Error code - average - standard deviation - total of the day The average and the standard deviation should be calculated based on the total by day for the last 30 days.
Project ID: 15582731

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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:
User Avatar
Been working for several years on MySQL queries and having a great knowledge of MySQL queries. Relevant Skills and Experience MySQL, SQL, PHP Proposed Milestones $22 USD - Understanding and writing optimized query
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
10 freelancers are bidding on average $39 USD for this job
User Avatar
Hi arayafr. do you need an mysql query that extracts and calculate the error codes that is exceeding for the total count of the day the upper control limit ?.I sure i can help you We have experience in thoses skills: PHP, SQL, MySQL SAVE your time and SAVE my time is my goal, do this project fast as possible and support you all time: now and feature Please text me via inbox to discuss with me about this task Relevant Skills and Experience PHP, SQL, MySQL Proposed Milestones $20 USD - for starting project We can Discuss custom Milestones
$40 USD in 5 days
5.0 (85 reviews)
6.4
6.4
User Avatar
Hello Sir, hope you are fine, I ready your job proposal closly and gather all the requirement which you are written proplerly I am interested in your work "to create mysql query". Relevant Skills and Experience I have 5 year experience in Web Development Service. You can view my profile for details to skills and customer feedback https://www.freelancer.com/u/kazimking Proposed Milestones $50 USD - Task 1 task is start after insertion of data from CSV or before ?
$50 USD in 2 days
4.9 (45 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$35 USD in 2 days
5.0 (3 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i have completed project in PHP, LARAVEL, CodeIgniter, Symfony and MYSQL. I shall complete project in short time. Regards, Nitu Patel Relevant Skills and Experience I have 2.8 years experience in CSS3, HTML5, JQUERY, PHP, LARAVEL, CodeIgniter, Symfony AND MYSQL. Proposed Milestones $30 USD - initial milestones $25 USD - second milestones
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of COSTA RICA
Grecia, Costa Rica
5.0
13
Payment method verified
Member since Feb 12, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.