Đang Thực Hiện

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

Kỹ năng: Big Data, MySQL, Kiến trúc phần mềm

Xem thêm: 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

Về Bên Thuê:
( 29 nhận xét ) Mount Waverley, Australia

Mã Dự Án: #14916693

Đã trao cho:

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 Thêm

$155 AUD trong 3 ngày
(1 Đánh Giá)
2.2

36 freelancer đang chào giá trung bình $144 cho công việc này

$147 AUD trong 3 ngày
(608 Đánh Giá)
8.4
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 Thêm

$350 AUD trong 3 ngày
(28 Đánh Giá)
7.2
androidc

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 Thêm

$147 AUD trong 3 ngày
(31 Đánh Giá)
5.8
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 Thêm

$180 AUD trong 3 ngày
(12 Đánh Giá)
5.3
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 Thêm

$150 AUD trong 1 ngày
(37 Đánh Giá)
5.3
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 Thêm

$200 AUD trong 3 ngày
(27 Đánh Giá)
5.6
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 trong 3 ngày
(42 Đánh Giá)
4.8
$111 AUD trong 3 ngày
(41 Đánh Giá)
5.0
$155 AUD trong 3 ngày
(2 Đánh Giá)
4.3
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 Thêm

$130 AUD trong 3 ngày
(7 Đánh Giá)
4.2
bhawin91

A proposal has not yet been provided

$222 AUD trong 3 ngày
(18 Đánh Giá)
4.2
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 trong 0 ngày
(11 Đánh Giá)
4.0
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 $ Thêm

$155 AUD trong 3 ngày
(8 Đánh Giá)
3.6
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 Thêm

$250 AUD trong 3 ngày
(7 Đánh Giá)
3.4
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 trong 3 ngày
(3 Đánh Giá)
3.5
djcarras

hi, i can help you with your project. send me more information about via [url removed, login to view] chat. regards Habilidades y experiencia relevante linux php html5 boostrap jquery mysql mariadb sql server Htos propuestos $133 Thêm

$133 AUD trong 3 ngày
(4 Đánh Giá)
3.0
$111 AUD trong 3 ngày
(5 Đánh Giá)
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 Thêm

$40 AUD trong 3 ngày
(2 Đánh Giá)
2.2
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, Thêm

$199 AUD trong 4 ngày
(5 Đánh Giá)
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 trong 3 ngày
(2 Đánh Giá)
1.2