Find Jobs
Hire Freelancers

MySQL query assistance

R210-1750 ZAR

Closed
Posted over 6 years ago

R210-1750 ZAR

Paid on delivery
I am looking for assistance to compile a MySQL query which involves calculating a daily moving average value and grouping those values based on a specific column. Using the attached dataset, if you run the following query: SELECT AVG(value), DATE(date), group, COUNT(value) FROM sample_data_new WHERE date >= '2017-10-10 00:00:00' AND (date <= ('2017-10-20' + INTERVAL 1 DAY)) GROUP BY group, DATE(date); You get a daily average for each unique group item. I'd like to modify the query to get a moving(sliding) daily average for the previous 7 days. Thus, the daily average for the date '2017-10-10' should be an average for all the days from '2017-10-03' up to '2017-10-10'. So an average has to be calculated for each day and then an average over 7 days for each day.
Project ID: 15703532

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average R870 ZAR for this job
User Avatar
Hello, I can assist you compile your MySQL query which involves calculating a daily moving average value and group those values based on a specific column. As for me, I am a professional system admin with 15 years of experience. You l free to contact me at your convenience so that we have a brief conversation.
R1,052 ZAR in 3 days
4.9 (68 reviews)
7.2
7.2
User Avatar
Hey A MySQL and SQL expert developer is here I have good advanced expertise in MySQL and database programming Feel Free to message me We can discuss about the details in chat Regards Stay tuned, I'm still working on this proposal.
R290 ZAR in 0 day
4.9 (163 reviews)
6.6
6.6
User Avatar
Hi, I have good proficiency in sql. you can go through my profile. most of the projects are in sql. I would like to calculate an average for each day and then an average over 7 days for each day. Relevant Skills and Experience sql, mysql Proposed Milestones R300 ZAR - half complete R366 ZAR - completion
R666 ZAR in 1 day
4.9 (128 reviews)
6.3
6.3
User Avatar
I can create this query. MySQL Expert with more than 12 year's experience here. Relevant Skills and Experience MySQL Proposed Milestones R500 ZAR - To be discussed
R500 ZAR in 1 day
4.9 (54 reviews)
6.0
6.0
User Avatar
i could update query as you need thanks
R240 ZAR in 1 day
4.8 (55 reviews)
5.4
5.4
User Avatar
Hello, How are you? I have read your project description carefully I am very interested in this project. I have a lot of experience in this type of work. I'm sure I can complete it on time with high quality according to your request please get in touch so that we can discuss more and I can start to work immediately. I'm always ready.
R1,000 ZAR in 3 days
5.0 (31 reviews)
5.1
5.1
User Avatar
Hello, I have expertise in database. Relevant Skills and Experience mysql Proposed Milestones R1088 ZAR - work
R1,088 ZAR in 1 day
4.6 (22 reviews)
4.9
4.9
User Avatar
Hello, i have good understanding of SQL queries and gone through your requirement. i can provide you required query. Let's have a quick chat. Relevant Skills and Experience MySQL, SQL Proposed Milestones R565 ZAR - SQL query
R565 ZAR in 1 day
5.0 (31 reviews)
4.4
4.4
User Avatar
mysql optimised query Relevant Skills and Experience Mysql Proposed Milestones R2222 ZAR - query Additional Services Offered R50 ZAR - support
R2,222 ZAR in 1 day
4.7 (5 reviews)
3.7
3.7
User Avatar
MySQL query help needed Relevant Skills and Experience MySql Proposed Milestones R1555 ZAR - MySQL query help needed
R1,666 ZAR in 1 day
4.3 (7 reviews)
3.6
3.6
User Avatar
Hi, I am expert in tuning anything, include sql tuning. I can give you answer in my server if you want to see the result. Then you can accept my bid if you satisfy. Thanks, catbig Relevant Skills and Experience Data Warehouse Consultant Proposed Milestones R1000 ZAR - Complete
R1,000 ZAR in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi! I have a large experience with PHP & MySQL and I can solve your problem.
R477 ZAR in 2 days
3.8 (1 review)
0.5
0.5
User Avatar
A proposal has not yet been provided
R555 ZAR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 5+ years experience in different databases like Oracle, MySQL, PostgreSQL and MSSQL. I would like to work on this project Relevant Skills and Experience Extensive experience in SQL, Performance Tuning Substantial development experience in creating DB objects Good knowledge in Data modeling, ETL and Data Warehouse Proposed Milestones R1000 ZAR - on Delivery
R1,000 ZAR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
South Africa
0.0
0
Member since Sep 9, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.