I only have one table and I want to count each entry of a tag starting from 0
Now I try this:
SELECT label, COUNT(start) AS Anzahl, user_id FROM datensammlung where (start='1') AND (user_id='1') GROUP BY label;
But the reward is only:
| Label | quantity | User ID |
|---|---|---|
| 1_Eating Spoon | 20 | 1 |
| 1_Blow your nose | 20 | 1 |
But I want this:
| Label | quantity | User ID |
|---|---|---|
| 1_Eating Spoon | 20 | 1 |
| 1_Blow your nose | 20 | 1 |
| 1_Telephone | 0 | 1 |
1
0
0
If all label are available in the table, you can use conditional aggregation:
SELECT label,
SUM(user_id = '1' AND start = '1') AS Anzahl
FROM datensammlung
GROUP BY label;
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
