CREATE TABLE  person (
   id int,
   name varchar(20),
   sale int,
   commission int
);
 
CREATE TABLE sale (
   id int,
   `date` date,
   person_id int,
   sale int,
   commission int
 );
 
 INSERT INTO person VALUES (1, 'abc', 0, 0), (2, 'xyz', 0, 0);
 
 INSERT INTO sale VALUES 
 (1, '2016-05-01', 1, 10, 1), 
 (2, '2016-05-02', 1, 10, 1), 
 (3, '2016-05-03', 1, 10, 1), 
 (4, '2016-05-01', 2, 20, 2), 
 (5, '2016-05-02', 2, 20, 2), 
 (6, '2016-05-01', 2, 20, 2);
 
 UPDATE person SET 
 sale = (
    SELECT SUM(s.sale) FROM sale s
    WHERE s.person_id = person.id
 ),
 commission = (
    SELECT SUM(s.commission) FROM sale s
    WHERE s.person_id = person.id
 );
 
 SELECT * FROM person;
 
 SELECT * FROM sale;
 

Q1JFQVRFIFRBQkxFICBwZXJzb24gKAogICBpZCBpbnQsCiAgIG5hbWUgdmFyY2hhcigyMCksCiAgIHNhbGUgaW50LAogICBjb21taXNzaW9uIGludAopOwoKQ1JFQVRFIFRBQkxFIHNhbGUgKAogICBpZCBpbnQsCiAgIGBkYXRlYCBkYXRlLAogICBwZXJzb25faWQgaW50LAogICBzYWxlIGludCwKICAgY29tbWlzc2lvbiBpbnQKICk7CiAKIElOU0VSVCBJTlRPIHBlcnNvbiBWQUxVRVMgKDEsICdhYmMnLCAwLCAwKSwgKDIsICd4eXonLCAwLCAwKTsKIAogSU5TRVJUIElOVE8gc2FsZSBWQUxVRVMgCiAoMSwgJzIwMTYtMDUtMDEnLCAxLCAxMCwgMSksIAogKDIsICcyMDE2LTA1LTAyJywgMSwgMTAsIDEpLCAKICgzLCAnMjAxNi0wNS0wMycsIDEsIDEwLCAxKSwgCiAoNCwgJzIwMTYtMDUtMDEnLCAyLCAyMCwgMiksIAogKDUsICcyMDE2LTA1LTAyJywgMiwgMjAsIDIpLCAKICg2LCAnMjAxNi0wNS0wMScsIDIsIDIwLCAyKTsKIAogVVBEQVRFIHBlcnNvbiBTRVQgCiBzYWxlID0gKAogICAgU0VMRUNUIFNVTShzLnNhbGUpIEZST00gc2FsZSBzCiAgICBXSEVSRSBzLnBlcnNvbl9pZCA9IHBlcnNvbi5pZAogKSwKIGNvbW1pc3Npb24gPSAoCiAgICBTRUxFQ1QgU1VNKHMuY29tbWlzc2lvbikgRlJPTSBzYWxlIHMKICAgIFdIRVJFIHMucGVyc29uX2lkID0gcGVyc29uLmlkCiApOwogCiBTRUxFQ1QgKiBGUk9NIHBlcnNvbjsKIAogU0VMRUNUICogRlJPTSBzYWxlOwog