(7)Selec S). SNO, Sl SNAMEfrom S SI, PPL, Spy spjwhere S| SN0= SPJ1. Sno and PI. Pno=Spl PNgrwp by $I. s nohav ing sum Price x TY) >=all( ee Sum (price米QTY)from S S2,PP2, Sp SPJ2Where S2 Sno= Spja. Sno AnoP2.PNB=SpT2.PN°r olS2. SN 0
(7)Selec S). SNO, Sl SNAMEfrom S SI, PPL, Spy spjwhere S| SN0= SPJ1. Sno and PI. Pno=Spl PNgrwp by $I. s nohav ing sum Price x TY) >=all( ee Sum (price米QTY)from S S2,PP2, Sp SPJ2Where S2 Sno= Spja. Sno AnoP2.PNB=SpT2.PN°r olS2. SN 0
发布时间:2024-09-28 16:52:05