I want to select the sum of piece for a specific case sharing the same job.
But I only want the result for the highest job.

I have the following table (3dprint)

```
+------+---------+-----------+--------+
| p_id | case_id | Qty_piece | job_id |
+------+---------+-----------+--------+
|    1 |     186 |         1 |      5 |
|    2 |     186 |         2 |      5 |
|    3 |     186 |         4 |      7 |
+------+---------+-----------+--------+

```

So I tried

```
SELECT SUM(Qty_piece) FROM 3dprint
WHERE 3dprint_caseID = 186 
ORDER BY 3dprint_jobID DESC LIMIT 1

```

But it give me 7. I want the 4. How to proceed to get this working ?