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: 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, Build web page showing rainfall data from mysql db, written test of data entry operator of idea project will be held on 6 feb 16 in tejgaon college dhaka download admit card from e, java i want a write a desktop application that requests data from a website, mysql exponential moving average, write search query using data structures java, mysql function moving average, magento mysql query sales

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

Proje NO: #14916693



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 Fazla

%selectedBids___i_period_sub_7% gün içinde 155%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(6 Değerlendirme)

30 freelancers are bidding on average $147 for this job

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(648 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)

Hi, I can calculate Average weekly, monthly and yearly also. I have 7 year experience in MySQL. Relevant Skills and Experience [url removed, login to view] [url removed, login to view] [url removed, login to view] http://socialterminal Daha Fazla

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(37 Değerlendirme)
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde130%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)

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 %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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 %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde132%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

i can do this for you Relevant Skills and Experience i have an experience of 1.5-2 years in this field Proposed Milestones $150 AUD - 1

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Dear, sir. I have read your proposal carefully. I have developed PC Application with MySQL 3+ years. I can do this project. Thanks. Relevant Skills and Experience C/C++, C#, Java, Delphi, MySQL, MS SQL, Proposed Mile Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I have experience working with data analysis, so I can this job for you. You probably need a function instead of a query because moving average is more complex than average and requires a range parameter. I have a q Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)