合工大数据库实验一答案
-- 查询供应商名称中包含“盛”字的供应商信息select * from supplier where supplier.sname like "%盛%";-- 2019213719-- 找出向北京供应商购买重量大于30的零件的工程名select jname from supplier, component, project, support where supplier.sno=support.sno and component.pno=support.pno and project.jno=.








