mysql過濾條件加總問題

ayabreay1

想請教各位大大，我要如何從以下表下sql抓取最後10筆00:20的keyboard的數量加總?

日期	時間	欄位	數量
2022/11/17	00:03	keyboard	88
2022/11/17	00:03	mouse	77
2022/11/17	00:03	trumpet	66
2022/11/17	00:03	screen	55
2022/11/17	00:20	keyboard	99
2022/11/17	00:20	mouse	66
2022/11/17	00:20	trumpet	55
2022/11/17	00:20	screen	33
2022/11/17	00:40	keyboard	22
2022/11/17	00:40	mouse	11
2022/11/17	00:40	trumpet	33
2022/11/17	00:40	screen	44
2022/11/17	00:55	keyboard	55
2022/11/17	00:55	mouse	66
2022/11/17	00:55	trumpet	77
2022/11/17	00:55	screen	88
2022/11/18	00:03	keyboard	88
2022/11/18	00:03	mouse	77
2022/11/18	00:03	trumpet	66
2022/11/18	00:03	screen	55
2022/11/18	00:20	keyboard	99
2022/11/18	00:20	mouse	66
2022/11/18	00:20	trumpet	55
2022/11/18	00:20	screen	33
2022/11/18	00:40	keyboard	22
2022/11/18	00:40	mouse	11
2022/11/18	00:40	trumpet	33
2022/11/18	00:40	screen	44
2022/11/18	00:55	keyboard	55
2022/11/18	00:55	mouse	66
2022/11/18	00:55	trumpet	77
2022/11/18	00:55	screen	88
2022/11/19	00:03	keyboard	88
2022/11/19	00:03	mouse	77
2022/11/19	00:03	trumpet	66
2022/11/19	00:03	screen	55
2022/11/19	00:20	keyboard	99
2022/11/19	00:20	mouse	66
2022/11/19	00:20	trumpet	55
2022/11/19	00:20	screen	33
2022/11/19	00:40	keyboard	22
2022/11/19	00:40	mouse	11
2022/11/19	00:40	trumpet	33
2022/11/19	00:40	screen	44
2022/11/19	00:55	keyboard	55
2022/11/19	00:55	mouse	66
2022/11/19	00:55	trumpet	77
2022/11/19	00:55	screen	88
2022/11/20	00:03	keyboard	88
2022/11/20	00:03	mouse	77
2022/11/20	00:03	trumpet	66
2022/11/20	00:03	screen	55
2022/11/20	00:20	keyboard	99
2022/11/20	00:20	mouse	66
2022/11/20	00:20	trumpet	55
2022/11/20	00:20	screen	33
2022/11/20	00:40	keyboard	22
2022/11/20	00:40	mouse	11
2022/11/20	00:40	trumpet	33
2022/11/20	00:40	screen	44
2022/11/20	00:55	keyboard	55
2022/11/20	00:55	mouse	66
2022/11/20	00:55	trumpet	77
2022/11/20	00:55	screen	88

...

瀏覽完整內容，請先 註冊 或 登入會員