3333SQLSQLSQLSQLsQLsQLsQLsQLsQLsQLsQLsQLDDLDDLDDLDDLDMLDMLDMLDMLDCLDCLDCLDCLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLsQLSQLSQLSQLSQLcREATEcREATETABLEABLEABLEABLEALTERALTERALTERALTERTABLETABLETABLETABLEDROPTABLEDROPTABLEDROPTABLEDROPTABLECREATEINDEXCREATEINDEXCREATEINDEXCREATEINDEXDROPINDEXDROPINDEXDROPINDEXDROPINDEXCREATECREATECREATECREATEVIEWVIEWVIEWVIEWDROPVIEWDROPVIEWDROPVIEWDROPVIEWsQLsQLsQLsQLCREATETABLEUNIQUEABLEUNIQUEABLEUNIQUEABLEStatusStatusStatusStatusCREATECREATECREATECREATETABLETABLETABLETABLEP(PnoP(PnoP(PnoP(PnoUNIQUEUNIQUEUNIQUEUNIQUEPnamePnamePnamePnameCOLORCOLORCOLORCOLORWEIGHTINT);WEIGHTINT);WEIGHTINT);WEIGHTINT);CREATECREATECREATECREATETTTTABLEABLEABLEABLEJ(JnoJ(JnoJ(JnoJ(JnoUNlQUEJNAMEJNAMEJNAMEJNAMEsPJsPJsPJsPJsPJQTYsPJQTYsPJQTYsPJSPJSPJSPJSPJSPJ(SNO,PNO,JNO,QTY)SPJ(SNO,PNO,JNO,QTY)SPJ(SNO,PNO,JNO,QTY)SPJ(SNO,PNO,JNO,QTY)CREATECREATETABLESPJ(SnoABLESPJ(SnoABLESPJ(SnoABLESPJ(SnoPnoPnoPnoPnoJNOJNOJNOJNOQTYQTYQTYQTYINT))INT))INT))INT))sQLsQLsQLsQLJlJlJlJlSNOJlJlJlJlPlPlPlPlSNOSELECTSELECTSELECTSELECTDISTSNOFROMSPJWHEREJNO='J1'PNO='P1'DISTSNOFROMSPJWHEREJNO='J1'PNO='P1'DISTSNOFROMSPJWHEREJNO='J1'PNO='P1'DISTSNOFROMSPJWHEREJNO='J1'Jl?Jl?Jl?SNO?;?SNO?;?SNO?;?JNO?;?JNO?;?JNO?;?SELECT?SELECT?SELECT?DIST?DIST?DIST?JNO?FROM?SPJ?JNO?FROM?SPJ?JNO?FROM?SPJ?WHERE?JNO?NOT?IN?(SELE?JNO?FROM?WHERE?JNO?NOT?IN?(SELE?JNO?FROM?WHERE?JNO?NOT?IN?(SELE?JNO?FROM?SPJ,P,S?SPJ,P,S?SPJ,P,S?WHERE?WHERE?WHERE?S.CITY='S.CITY='S.CITY='AND?COLOR='COLOR='COLOR='AND?S.SNO=SPJ.SNO?S.SNO=SPJ.SNO?S.SNO=SPJ.SNO?P.PNO=SPJ.PNO)P.PNO=SPJ.PNO)P.PNO=SPJ.PNO)Sl?Sl?Sl?JNO?;?JNO?;?JNO?;?55SQLSQLSQLSELECT?SNAME,CITY?FROM?S?SELECT?SNAME,CITY?FROM?S?SELECT?SNAME,CITY?FROM?S?SELECT?PNAME,COLOR,WEIGHT?FROM?P?SELECT?PNAME,COLOR,WEIGHT?FROM?P?SELECT?PNAME,COLOR,WEIGHT?FROM?P?S1S1S1SELECT?SELECT?SELECT?DIST?JNO?FROM?SPJ?WHERE?SNO='S1'?DIST?JNO?FROM?SPJ?WHERE?SNO='S1'?DIST?JNO?FROM?SPJ?WHERE?SNO='S1'?J2J2J2SELECT?PNAME,QTY?FROM?SPJ,P?SELECT?PNAME,QTY?FROM?SPJ,P?SELECT?PNAME,QTY?FROM?SPJ,P?WHERE?P.PNO=SPJ.PNO?AND?SPJ.JNO='J2'?WHERE?P.PNO=SPJ.PNO?AND?SPJ.JNO='J2'?WHERE?P.PNO=SPJ.PNO?AND?SPJ.JNO='J2'?SELECT?PNO?FROM?SPJ,S?WHERE?S.SNO=SPJ.SNO?AND?CITY='SELECT?PNO?FROM?SPJ,S?WHERE?S.SNO=SPJ.SNO?AND?CITY='SELECT?PNO?FROM?SPJ,S?WHERE?S.SNO=SPJ.SNO?AND?CITY='SELECT?JNAME?FROM?SPJ,S,J?SELECT?JNAME?FROM?SPJ,S,J?SELECT?JNAME?FROM?SPJ,S,J?WHERE?S.SNO=SPJ.SNO?AND?S.CITY='WHERE?S.SNO=SPJ.SNO?AND?S.CITY='WHERE?S.SNO=SPJ.SNO?AND?S.CITY=''?AND?J.JNO=SPJ.JNO?'?AND?J.JNO=SPJ.JNO?'?AND?J.JNO=SPJ.JNO?:?SELECT?SELECT?SELECT?DISP?DISP?DISP?JNO?JNO?JNO?FROM?FROM?FROM?SPJ?SPJ?SPJ?WHERE(初心和使命是什么？初心和使命就是為中國人民謀幸福，為中華民族謀復(fù)興。為奪取新時代中國特色社會主義偉大勝利，為實現(xiàn)中華民族偉大復(fù)興的中國夢不懈奮斗。)?WHERE?WHERE?JNO?JNO?JNO?IN?(SELECT?(SELECT?(SELECT?DIST?DIST?DIST?JNO?JNO?JNO? FROM? FROM? FROM?SPJ,S? SPJ,S? SPJ,S?WHERE? WHERE? WHERE?S.SNO=SPJ.SNO? S.SNO=SPJ.SNO? S.SNO=SPJ.SNO?AND? AND?S.CITY='S.CITY=' S.CITY=' JNOJNO JNO :?SELECT?DIST?JNO?FROM?SPJ,S?WHERE?S.SNO=SPJ.SNO?AND?S.CITY':?SELECT?DIST?JNO?FROM?SPJ,S?WHERE?S.SNO=SPJ.SNO?AND?S.CITY' :?SELECT?DIST?JNO?FROM?SPJ,S?WHERE?S.SNO=SPJ.SNO?AND?S.CITY'