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

Taidot: Big Data, MySQL, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

About the Employer:
( 28 reviews ) Mount Waverley, Australia

Projektin tunnus: #14916693

Myönnetty käyttäjälle:


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 Lisää

155 $ AUD 3 päivässä
(1 arvostelu)

38 freelanceria on tarjonnut keskimäärin 149 $ tähän työhön

147 $ AUD 3 päivässä
(603 arvostelua)

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 Lisää

350 $ AUD 3 päivässä
(28 arvostelua)

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 Lisää

200 $ AUD 3 päivässä
(27 arvostelua)

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 Lisää

180 $ AUD 3 päivässä
(12 arvostelua)

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 Lisää

147 $ AUD 3 päivässä
(31 arvostelua)

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 Lisää

150 $ AUD 1 päivässä
(37 arvostelua)

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 3 päivässä
(39 arvostelua)
111 $ AUD 3 päivässä
(41 arvostelua)

A proposal has not yet been provided

222 $ AUD 3 päivässä
(18 arvostelua)

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 Lisää

130 $ AUD 3 päivässä
(7 arvostelua)
155 $ AUD 3 päivässä
(2 arvostelua)

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 0 päivässä
(11 arvostelua)

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 Lisää

250 $ AUD 3 päivässä
(7 arvostelua)

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 $ Lisää

155 $ AUD 3 päivässä
(6 arvostelua)

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 Lisää

133 $ AUD 3 päivässä
(4 arvostelua)
111 $ AUD 3 päivässä
(5 arvostelua)

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 Lisää

40 $ AUD 3 päivässä
(2 arvostelua)

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 3 päivässä
(3 arvostelua)

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, Lisää

199 $ AUD 4 päivässä
(5 arvostelua)

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 3 päivässä
(2 arvostelua)