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(初心和使命是什么？初心和使命就是为中国人民谋幸福，为中华民族谋复兴。为夺取新时代中国特色社会主义伟大胜利，为实现中华民族伟大复兴的中国梦不懈奋斗。) 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'