MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.7.35


CREATE TABLE ServiceOrder (No_ varchar(20));
INSERT INTO ServiceOrder VALUES ('SO2101234');
INSERT INTO ServiceOrder VALUES ('SO2101235');
INSERT INTO ServiceOrder VALUES ('SO2101237');
INSERT INTO ServiceOrder VALUES ('SO2101239');

CREATE TABLE PreRecording (No_ varchar(20), Line int, Amount int);
INSERT INTO PreRecording VALUES ('SO2101234', 1, 50);
INSERT INTO PreRecording VALUES ('SO2101234', 2, 18);
INSERT INTO PreRecording VALUES ('SO2101239', 1, 110);
INSERT INTO PreRecording VALUES ('SO2101239', 2, 40);
INSERT INTO PreRecording VALUES ('SO2101239', 3, 40);

CREATE TABLE InvoiceHeader (No_ varchar(20), So varchar(20));
INSERT INTO InvoiceHeader VALUES ('VF2134889', 'SO2101234');
INSERT INTO InvoiceHeader VALUES ('VF2134890', 'SO2101235');
INSERT INTO InvoiceHeader VALUES ('VF2134891', 'SO2101239');
INSERT INTO InvoiceHeader VALUES ('VF2134892', 'SO2101234');
INSERT INTO InvoiceHeader VALUES ('VF2134893', 'SO2101239');

CREATE TABLE InvoiceLine (DocNo_ varchar(20), LineNo int, LineAmount int);
INSERT INTO InvoiceLine VALUES ('VF2134889', 1, 55);
INSERT INTO InvoiceLine VALUES ('VF2134889', 2, 23);
INSERT INTO InvoiceLine VALUES ('VF2134890', 1, 12);
INSERT INTO InvoiceLine VALUES ('VF2134890', 2, 34);
INSERT INTO InvoiceLine VALUES ('VF2134890', 3, 87);
INSERT INTO InvoiceLine VALUES ('VF2134891', 1, 114);
INSERT INTO InvoiceLine VALUES ('VF2134892', 1, 53);
INSERT INTO InvoiceLine VALUES ('VF2134892', 2, 25);
INSERT INTO InvoiceLine VALUES ('VF2134892', 3, 17);
INSERT INTO InvoiceLine VALUES ('VF2134892', 4, 15);
INSERT INTO InvoiceLine VALUES ('VF2134893', 1, 43);
INSERT INTO InvoiceLine VALUES ('VF2134893', 2, 38);
SELECT * FROM ServiceOrder;
SELECT * FROM PreRecording;
SELECT * FROM InvoiceHeader;
SELECT * FROM InvoiceLine;


No_


SO2101234

SO2101235

SO2101237

SO2101239




No_
Line
Amount


SO2101234
1
50

SO2101234
2
18

SO2101239
1
110

SO2101239
2
40

SO2101239
3
40




No_
So


VF2134889
SO2101234

VF2134890
SO2101235

VF2134891
SO2101239

VF2134892
SO2101234

VF2134893
SO2101239




DocNo_
LineNo
LineAmount


VF2134889
1
55

VF2134889
2
23

VF2134890
1
12

VF2134890
2
34

VF2134890
3
87

VF2134891
1
114

VF2134892
1
53

VF2134892
2
25

VF2134892
3
17

VF2134892
4
15

VF2134893
1
43

VF2134893
2
38


   SELECT SO.No_, SUM(PR.Amount) AS SumAmount
     FROM ServiceOrder SO 
LEFT JOIN PreRecording PR 
       ON PR.No_ = SO.No_
 GROUP BY SO.No_


No_
SumAmount


SO2101234
68

SO2101235
null

SO2101237
null

SO2101239
190


SELECT 
    PRGRP.No_, COALESCE(PRGRP.SumAmount, 0) AS PRAmount,
    COALESCE(SUM(IL.LineAmount), 0) AS ILAmount
  FROM ( SELECT SO.No_, SUM(PR.Amount) AS SumAmount
           FROM ServiceOrder SO 
      LEFT JOIN PreRecording PR 
             ON PR.No_ = SO.No_
       GROUP BY SO.No_
      ) PRGRP
LEFT JOIN InvoiceHeader IH 
       ON IH.SO = PRGRP.No_
LEFT JOIN InvoiceLine IL 
       ON IL.DocNo_ = IH.No_
 GROUP BY PRGRP.No_


No_
PRAmount
ILAmount


SO2101234
68
188

SO2101235
0
133

SO2101237
0
0

SO2101239
190
195
No_	Line	Amount
SO2101234	1	50
SO2101234	2	18
SO2101239	1	110
SO2101239	2	40
SO2101239	3	40
No_	So
VF2134889	SO2101234
VF2134890	SO2101235
VF2134891	SO2101239
VF2134892	SO2101234
VF2134893	SO2101239