数据库的查询,我不会用,也不理解

img


兄弟们,救救孩子,孩子啥都不会快期末考试了

SELECT zg.ZGname, ck.CKname, ck.CKkind, zg.ZGjob, zg.ZGsal FROM ZG zg
INNER JOIN CK ck ON ck.CK# = zg.CK#
WHERE ck.CKname = '配件' OR ck.CKname = '整机'

SELECT bm.Zlede, ck.CKleader, ck.CKname, ck.CKkind FROM ZCBM bm
INNER JOIN CK ck ON ck.BM# = bm.BM#
WHERE ck.CKloca <> '二分厂'

UPDATE ZG SET ZGsal = ZGsal*1.05 WHERE CK# = 'Col15' AND (ZGjob = '负责人' OR ZGjob = '技术员')

SELECT zg.ZG#, zg.ZGname FROM ZG zg WHERE zg.ZGsal > (SELECT MAX(ZGsal) FROM ZG WHERE CK# = 'C033') ORDER BY zg.ZGsal DESC