Sedang Disiapkan

MySQL weekly moving average query on sales data

From a mysql table orders_history, calculate the weekly moving average. I would also like be able to calculate a 4 week and a 12 week moving average.

Use mysql to calculate.

I have simple table called orders_hjstory that contains sales transactional data.

Want previous experience in similar project.

Will provide sample table schema and data on request.

The current data i have contains over 1million rows so the query needs to be optimised.

I have successfully written a query to give me the weekly average, now I would like the moving average

Kemahiran: Big Data, MySQL, Kejuruteraan Perisian

Lihat lebih lanjut: sql moving average query, postgresql moving average, sql server 2012 rolling average, mysql moving average, moving average sql oracle, sql 30-day moving average, redshift rolling average, 7 day moving average in sql, mysql exponential moving average, mysql function moving average, magento mysql query sales, mysql moving average function, mysql moving average gaps, mysql moving average formulas, mysql moving average

Tentang Majikan:
( 28 ulasan ) Mount Waverley, Australia

ID Projek: #14916693

Dianugerahkan kepada:

hlozada

Currently working with Forex (Metatrader 4) and able to perform the query you require (Moving average) and other calculations like this. I have experience with data mining and automation. Stay tuned, I'm still workin Lagi

$155 AUD dalam 3 hari
(1 Ulasan)
2.2

38 pekerja bebas membida secara purata $149 untuk pekerjaan ini

$147 AUD dalam 3 hari
(603 Ulasan)
8.3
A2Design

Hello! We are A2 Design, a Russian-Canadian web development company. If you you need help with: - Website/web application/e-commerce development (any complexity) from scratch or using a premade solution - Front-e Lagi

$350 AUD dalam 3 hari
(28 Ulasan)
7.2
vlad70

Hello Sir, as DBA I work with databases more than 15 years, more than 5 with MySQL. work with reports and experienced in complicated SQL queries would be happy to help Relevant Skills and Experience deep SQL knowledg Lagi

$200 AUD dalam 3 hari
(27 Ulasan)
5.6
vicboyvera

I have applied WMA in stocks for another client. I am skilled in PHP, JavaScript, MySQL. I am quite keen in making optimizations as well. I can do the job, mate. Relevant Skills and Experience PHP, MySQL, node.js, you Lagi

$180 AUD dalam 3 hari
(12 Ulasan)
5.3
androidc

Hi, I can calculate Average weekly, monthly and yearly also. I have 7 year experience in MySQL. Relevant Skills and Experience www.wedmegood.com/ www.newviewmoving.com/ http://www.ellebates.com/ http://socialterminal Lagi

$147 AUD dalam 3 hari
(31 Ulasan)
5.7
mahmoudgamal008

I have more than 5 years of professional and practical experience in MySQL, and database development. Relevant Skills and Experience I wrote hundreds and hundreds of SQL queries. I have more than 1800 answers in Stack Lagi

$150 AUD dalam sehari
(37 Ulasan)
5.3
mauricemarinus

I may have a query that works. Send me the table and data. Relevant Skills and Experience 17 years software developer Proposed Milestones $30 AUD - Description

$30 AUD dalam 3 hari
(39 Ulasan)
4.7
$111 AUD dalam 3 hari
(41 Ulasan)
5.0
bhawin91

A proposal has not yet been provided

$222 AUD dalam 3 hari
(18 Ulasan)
4.2
partsgr12

Hi, I am database developer with mysql experience. I propose to work with you. You have any queries or specific requirements, Please let me know. Regards Sankar Relevant Skills and Experience I am database develo Lagi

$130 AUD dalam 3 hari
(7 Ulasan)
4.2
$155 AUD dalam 3 hari
(2 Ulasan)
4.3
shennz

hi, Ready to start right now. I can provide quality and standard work. Experienced in MySQL and using aggregate functions. Please PM me for more details. Thank you

$35 AUD dalam 0 hari
(11 Ulasan)
3.9
kashivw

Veteran (15+ years) database developer. Worked previously in US Healthcase and International Banking (Citibank, Deutsche Bank) Similar projects done here, on Upwork and outside (non Upwork/Freelancer) Relevant Skills Lagi

$250 AUD dalam 3 hari
(7 Ulasan)
3.4
janggang

Hello Your job is very matched to me. I specialize in Mysql, and php. so, I can do your job perfectly and at a short time. Relevant Skills and Experience Big Data, MySQL, Software Architecture Proposed Milestones $ Lagi

$155 AUD dalam 3 hari
(6 Ulasan)
3.1
djcarras

hi, i can help you with your project. send me more information about via freelancer.com chat. regards Habilidades y experiencia relevante linux php html5 boostrap jquery mysql mariadb sql server Htos propuestos $133 Lagi

$133 AUD dalam 3 hari
(4 Ulasan)
3.0
$111 AUD dalam 3 hari
(5 Ulasan)
2.8
JulianHQ

Write an optimized SQL query to calculate the desired data. Relevant Skills and Experience SQL, Code optimizing. Proposed Milestones $40 AUD - Write SQL query I'd like to take a more in-depth look on the data and ha Lagi

$40 AUD dalam 3 hari
(2 Ulasan)
2.2
poojamishra13

Hi, i am expert developer, i would like to make this query. Thanks Relevant Skills and Experience Big Data, MySQL, Software Architecture Proposed Milestones $222 AUD - Default

$222 AUD dalam 3 hari
(3 Ulasan)
1.8
frankoke16

I can help you with this project. I am a full time programmer. I just wanted to have another job to gain more skills, learn from others and help others to solve their problems. I use .Net framework integrated with SQL, Lagi

$199 AUD dalam 4 hari
(5 Ulasan)
2.1
bs505

Hello I read your description I think I can do it well Relevant Skills and Experience php, mysql wordpress Proposed Milestones $155 AUD - in 3 days

$155 AUD dalam 3 hari
(2 Ulasan)
1.2