AYUDA SQL
Publicado por manu (1 intervención) el 26/11/2018 22:07:25
Hola pipol,
Necesito programar una consulta:
para crear una tabla asi
Store...........Customer_ID..........Month_Date.......Order_Count.........Order_Count_Same_Month_Last_Year
JustFab..........123.......................01/01/2016..................2.................................0
JustFab..........123.....................03/01/2016................2..................................0
JustFab..........123.....................08/01/2016................1..................................0
JustFab............123.....................01/01/2017..............3..................................2
JustFab............123....................03/01/2017...............1..................................2
No se como contabilizar los order_count por mes y año de cada customer para la ODER_COUNT
y no se como contar las order_count de año anterior ...
no se si me podéis echar un cable!
SELECT A.store.name, A.cutomer_id, B.Month_date,
CASE WHEN year(b.month_date)=2017 AND month (month_date) = 1 THEN COUNT (A.Order_Count)
ELSE year(b.month_date)=year(a.date) AND month (month_date) = 2 THEN COUNT (A.Order_Count)
ELSE year(b.month_date)=2017 AND month (month_date) = 3 THEN COUNT (A.Order_Count)
ELSE -- y asi hasta 12--- ,
CASE WHEN year(b.month_date)=2016 AND month (month_date) = 1 THEN COUNT (A.Order_Count)
ELSE year(b.month_date)=2016 AND month (month_date) = 2 THEN COUNT (A.Order_Count)
ELSE.. -- y asi hasta el 12---,
,
FROM tablax a, tablay b,
order by customer_id
gracias :)
Necesito programar una consulta:
para crear una tabla asi
Store...........Customer_ID..........Month_Date.......Order_Count.........Order_Count_Same_Month_Last_Year
JustFab..........123.......................01/01/2016..................2.................................0
JustFab..........123.....................03/01/2016................2..................................0
JustFab..........123.....................08/01/2016................1..................................0
JustFab............123.....................01/01/2017..............3..................................2
JustFab............123....................03/01/2017...............1..................................2
No se como contabilizar los order_count por mes y año de cada customer para la ODER_COUNT
y no se como contar las order_count de año anterior ...
no se si me podéis echar un cable!
SELECT A.store.name, A.cutomer_id, B.Month_date,
CASE WHEN year(b.month_date)=2017 AND month (month_date) = 1 THEN COUNT (A.Order_Count)
ELSE year(b.month_date)=year(a.date) AND month (month_date) = 2 THEN COUNT (A.Order_Count)
ELSE year(b.month_date)=2017 AND month (month_date) = 3 THEN COUNT (A.Order_Count)
ELSE -- y asi hasta 12--- ,
CASE WHEN year(b.month_date)=2016 AND month (month_date) = 1 THEN COUNT (A.Order_Count)
ELSE year(b.month_date)=2016 AND month (month_date) = 2 THEN COUNT (A.Order_Count)
ELSE.. -- y asi hasta el 12---,
,
FROM tablax a, tablay b,
order by customer_id
gracias :)
Valora esta pregunta
0
