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