Devam Ediyor

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

Beceriler: Büyük Veri, MySQL, Yazılım Mimarisi

Daha fazlasını görün: 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

İşveren Hakkında:
( 28 değerlendirme ) Mount Waverley, Australia

Proje NO: #14916693

Seçilen:

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 Daha fazlası

3 gün içinde 155$ AUD
(1 Değerlendirme)
2.2

38 freelancer bu iş için ortalamada 149$ teklif veriyor

in 3 gün içinde147$ AUD
(603 Değerlendirme)
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 Daha fazlası

in 3 gün içinde350$ AUD
(28 Değerlendirme)
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 Daha fazlası

in 3 gün içinde200$ AUD
(27 Değerlendirme)
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 Daha fazlası

in 3 gün içinde180$ AUD
(12 Değerlendirme)
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 Daha fazlası

in 3 gün içinde147$ AUD
(31 Değerlendirme)
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 Daha fazlası

1 gün içinde 150$ AUD
(37 Değerlendirme)
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

in 3 gün içinde30$ AUD
(39 Değerlendirme)
4.7
in 3 gün içinde111$ AUD
(41 Değerlendirme)
5.0
bhawin91

A proposal has not yet been provided

in 3 gün içinde222$ AUD
(18 Değerlendirme)
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 Daha fazlası

in 3 gün içinde130$ AUD
(7 Değerlendirme)
4.2
in 3 gün içinde155$ AUD
(2 Değerlendirme)
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

in 0 gün içinde35$ AUD
(11 Değerlendirme)
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 Daha fazlası

in 3 gün içinde250$ AUD
(7 Değerlendirme)
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 $ Daha fazlası

in 3 gün içinde155$ AUD
(6 Değerlendirme)
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 Daha fazlası

in 3 gün içinde133$ AUD
(4 Değerlendirme)
3.0
in 3 gün içinde111$ AUD
(5 Değerlendirme)
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 Daha fazlası

in 3 gün içinde40$ AUD
(2 Değerlendirme)
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

in 3 gün içinde222$ AUD
(3 Değerlendirme)
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, Daha fazlası

in 4 gün içinde199$ AUD
(5 Değerlendirme)
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

in 3 gün içinde155$ AUD
(2 Değerlendirme)
1.2