Fermé

Create Simple Query for Moving Average of Sales

Create Simple Query for Moving Average of Sales

I have a table that has sales entries over time, with fields: customer_number, sales_amount, and process_date.

I want to look at

1) weekly sales amounts

2) and find the weekly moving average

3) and determine if the last 4 weeks of sales have dropped below 20% of the latest moving average

Output will be:

customer_number, sales_below_flag

with 1 row for each customer

Compétences : Architecture Logicielle, Tests / QA

Voir plus : average sales commission, average sales commision search engine marketing, average sales commission construction contracts, python query results create csv file, cms simple create calendar, php simple create, average sales agency commission, telemarketing average sales data, use text simple create picture, query simple sql

Concernant l'employeur :
( 7 commentaires ) Fowler, United States

N° du projet : #8531194

6 freelance ont fait une offre moyenne de 45 $ pour ce travail

esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I am ready Plus

166 $ USD en 5 jours
(3 Commentaires)
5.7
sameerdes

Hi , I am sending below query for the first output required . Select customer_id, WeekNumber, sum(amount) from ( SELECT customer_id, WEEK(process_date) AS WeekNumber, amount FROM s Plus

15 $ USD en 3 jours
(0 Commentaires)
0.0
ritika12sal

A proposal has not yet been provided

25 $ USD en 2 jours
(0 Commentaires)
0.0
Nomakram1

Respected Sir, Thank you for taking the time to read our initial posting. I have read initial project description and i am ready to start this project. For further details, please message in the pmb. Look forwar Plus

13 $ USD en 0 jours
(0 Commentaires)
0.0
freelancerqa007

hi there, i have more then 3 year experience in software testing. i have done manual testing and automation testing both. check my linkedin profile. My skype Id is : [url removed, login to view] [url removed, login to view] Plus

10 $ USD en 1 jour
(0 Commentaires)
0.0
prashant19785

A proposal has not yet been provided

30 $ USD en 2 jours
(0 Commentaires)
0.0
tianaina

Hi, I've been a PHP-Mysql developer. What database do you use? Can you please give me the structure of your database? Regards

25 $ USD en 1 jour
(0 Commentaires)
0.0