[SQL]Jak zsumowac dane z dwoch roznych kategorii dla uzytkownikow pod wzgledem daty Opcje

[funPi]

Hej
Mam taka tabele:

-------------------------------------------
01-03-2017 | Adam | process_1 | 2 | S
-------------------------------------------
01-03-2017 | Adam | process_1 | 4 | M
-------------------------------------------
01-03-2017 | Adam | process_2 | 3| M
-------------------------------------------
01-03-2017 | Adam | process_2 | 7| L
-------------------------------------------
03-03-2017 | Lukasz | process_1 | 5| S
-------------------------------------------
03-03-2017 | Lukasz | process_1 | 8| M
-------------------------------------------
03-03-2017 | Lukasz | process_2 | 2| S
-------------------------------------------
03-03-2017 | Lukasz | process_2 | 4| M
-------------------------------------------
04-03-2017 | Piotr | process_1 | 3| L
-------------------------------------------
04-03-2017 | Piotr | process_1 | 11| M
-------------------------------------------
04-03-2017 | Piotr | process_2 | 5| L
-------------------------------------------
04-03-2017 | Piotr | process_2 | 9| M
-------------------------------------------
03-02-2017 | Lukasz | process_1 | 5| M
-------------------------------------------
03-02-2017 | Lukasz | process_1 | 8| S
-------------------------------------------
03-02-2017 | Lukasz | process_2 | 3| L
-------------------------------------------
03-02-2017 | Lukasz | process_2 | 3| M

To na czym mi zalezy to na zsumowaniu kolumny count dla kazdej osoby dla danego dnia ,sumujac process_1 z process_2 ,wiec w odpowiedzi powinienien dostac cos takiego:

Date | Name | Sum

------------------------------------
01-03-2017 | Adam | 16
------------------------------------
03-03-2017 | Lukasz | 19
--------------------------------------
04-03-2017 | Piotr | 28
------------------------------------
03-02-2017 | Lukasz | 19

Zatrzymalem sie na takim kodzie :

SELECT date, name, SUM(count) AS Sum
FROM table1
AND Process IN (
'process_1',
'process_2'
)
GROUP BY name;

I dalej nie mam pomyslu .

Pozdrawiam

Ten post edytował funPi 8.03.2017, 10:36:31

[Lion]

Pogrupuj także po date:

SELECT date, name, SUM(count) AS Sum
FROM table1
AND Process IN (
'process_1',
'process_2'
)
GROUP BY name, date;