select noms1. selectnoms fromevenements wheredescriptionlike'%dechets%'anddatediff(curdate(),datee)
TRANSCRIPT
-
1.SELECTnomSFROMEvenementsWHEREdescriptionLIKE'%dechets%'ANDDATEDIFF(CURDATE(),dateE)<365;
SELECTnomSFROMEvenementsWHEREdescriptionLIKE'%dechets%'INTERSECTSELECTnomSFROMEvenementsWHEREDATEDIFF(CURDATE(),dateE)<365;
2.SELECT*FROMSNWHEREpuissance>(SELECTpuissanceFROMSNWHEREnomS='Tricastin');
3.SELECT*FROMSNWHEREnomSIN(SELECTnomSFROMEvenementsWHEREniveau>=4);
4.SELECTnomSFROMSNWHEREnbReacteurs=6UNIONSELECTnomSFROMEvenementsWHEREdescriptionLIKE'%Fuku%';
5.SELECT*FROMSNWHEREnbReacteurs>ANY(SELECTnbReacteursFROMSNNATURALJOINDepWHEREnomD='Ain');
6.SELECTlabelTFROMTypeEvenementsNATURALJOINEvenementsWHEREniveau<ALL(SELECTniveauFROMEvenementsNATURALJOINTypeEvenementsWHERElabelT='fusiond\'uranium');
7.SELECT*FROMDepWHEREnumDNOTIN(SELECTnumDFROMSNNATURALJOINEvenementsWHEREYEAR(dateE)=2020);
8.SELECT*FROMDepdWHERENOTEXISTS(SELECT*FROMSNNATURALJOINEvenementsWHEREYEAR(dateE)=2020ANDSN.numD=d.numD);
9.SELECTnumD,nomDFROMDepEXCEPTSELECTd.numD,nomDFROMDepdNATURALJOINSNNATURALJOINEWHEREYEAR(dateE)=2020;