In Progress

Create a Mysql query

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.

Skills: MySQL, PHP, SQL

See more: how to create table in mysql command line, how to create table in mysql workbench, mysql create table foreign key, mysql create table primary key, mysql create table auto_increment, how to select database in mysql, create table mysql example, insert into table mysql, error 1317 mysql query execution interrupted dumping table, mysql query database table remote computer, mysql query remote database table, php mysql query format table, mysql query php table css, create mysql database form, create access database table using, create mysql email database, create database table xml schema, phpfilenavigator create mysql database, php mysql query table, create mysql table form data

About the Employer:
( 12 reviews ) Grecia, Costa Rica

Project ID: #15582731

Awarded to:

programmer2017

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 Reviews)
0.0

12 freelancers are bidding on average $37 for this job

$50 USD in 1 day
(47 Reviews)
5.6
jarki2017

I can do it. Relevant Skills and Experience sql Proposed Milestones $25 USD - m

$25 USD in 1 day
(13 Reviews)
5.5
$50 USD in 1 day
(28 Reviews)
5.2
kazimking

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 h More

$50 USD in 2 days
(27 Reviews)
4.7
RidwanNizam

A proposal has not yet been provided

$35 USD in 2 days
(3 Reviews)
4.3
MyAwesomeTeam

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 t More

$40 USD in 5 days
(4 Reviews)
3.6
utkarshv43

I will assure you quality work

$30 USD in 1 day
(3 Reviews)
3.4
$25 USD in 1 day
(1 Review)
0.0
sanakashif906

A proposal has not yet been provided

$35 USD in 2 days
(0 Reviews)
0.0
tuanthanhle

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)
0.0
nitupatel

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 More

$55 USD in 2 days
(0 Reviews)
0.0