STUCK: group function sum() is not working

Tables-:
SUPPLIERS(sno, sname, status, scity)
PARTS(pno, pname, color, weight)
PROJECT(jno, jname, jcity)
SHIPMENT(sno, jno, pno, quantity)

Q: For each shipment ,get full details including total shipment weights.

Hi. Can you provide us more details?

I tried everything but can’t figure out how to execute this query (Tables are given above)
For each shipment ,get full details including total shipment weights.

We can’t do much for you unless you can show us the code, unfortunately.