En cours

Mysql Query

Hi.

I am needing to create a report and need someone with good knowledge of SQL (MySQL) to create a query.

Basically I have a table that stores price variation with the following structure:

created | id_store | id_product | price

2012-07-20 1 1 [url removed, login to view]

2012-07-20 2 1 [url removed, login to view]

2012-07-20 3 1 [url removed, login to view]

2012-07-20 4 1 [url removed, login to view]

2012-07-23 1 1 [url removed, login to view]

2012-07-24 1 2 [url removed, login to view]

2012-07-24 2 2 [url removed, login to view]

2012-07-24 3 2 [url removed, login to view]

The query should accept a parameter id_store and perform a comparison of prices with others stores and then return the following result:

Parameters Example: id_store = 1 and stores to compare (2,3)

in the example below the id_store 4 is not computed

date | below | equal | above

2012-07-20 0 0 2

2012-07-21 0 0 2 ->>> Same result because nothing change

2012-07-22 0 0 2 ->>> Same result because nothing change

2012-07-23 2 0 0 ->>> The price now is above the store 2 and 3

2012-07-24 2 0 2 ->>> Now the product 1 is the same nothing chage but product 2 has two store that sell above....

I have a calendar table with contain a datefield to help with join

Tks...

Compétences : MySQL, SQL

Voir plus : structure stores, sql create table price, n query, sql mysql, query table, mysql report, mysql query, mysql calendar table, mysql join table, mysql table join, mysql structure, create sql report, mysql help table, sql create report, sql query help, mysql join, comparison table, mysql query example, price comparison mysql, create report mysql, 2012 calendar table, compare product parameter, calendar table 2012, store comparison report, 2012 table calendar

Concernant l'employeur :
( 1 commentaire ) São Paulo, Brazil

N° du projet : #2371525

Décerné à :

MOrigoni

Hi adrianogf, I have good experience creating report queries in MySQL. I can have you query done in a couple of hours. Marcelo

60 $ USD en 0 jours
(8 Commentaires)
3.9

15 freelance ont fait une offre moyenne de 63 $ pour ce travail

becomeexpert

Seen and understood. Nice problem. Can do it easily. Thanks.

100 $ USD en 1 jour
(13 Commentaires)
6.6
Ciofi

Hello, We can do this for you right now if you want. We are SQL experts.

30 $ USD en 0 jours
(14 Commentaires)
5.1
vladim1

Will do search form+query script+report page. Let start

100 $ USD en 1 jour
(21 Commentaires)
5.1
manhpham

Hi, I am Mysql expert. I can help you right now. Please give me your contact.

50 $ USD en 1 jour
(16 Commentaires)
4.5
rakhon

Hi, I can do it...

50 $ USD en 0 jours
(5 Commentaires)
3.3
SSADeveloper

i can help you,sir!

100 $ USD en 1 jour
(3 Commentaires)
3.0
malik0321

I can do it.Send PM

70 $ USD en 0 jours
(2 Commentaires)
2.7
alihaidermalik

We have 5 years experience in web designing and development. we understand what you need. so we are ready to done it.

100 $ USD en 2 jours
(0 Commentaires)
0.0
above

Hi, I got about 8 years experience of web development and would love to solve this SQL query. Can start immediately.

50 $ USD en 1 jour
(0 Commentaires)
0.0
sharadkumar1950

Please check the PMB.

30 $ USD en 1 jour
(0 Commentaires)
0.0
itsymphonia

Hi! I can help with your problem, see PM please

30 $ USD en 1 jour
(0 Commentaires)
0.0
guruved

Hi, I have good experience on MYSQL.I can deliver you within a couple of hours with accurate result.

30 $ USD en 0 jours
(0 Commentaires)
0.0
yugiohhus89

hi, i can done it for you. please Pm to me. thanks!

30 $ USD en 0 jours
(0 Commentaires)
1.3
nipunone

GIVE ME DETAILS WILL DO THIS

120 $ USD en 1 jour
(0 Commentaires)
0.0