-- your code goes here
 
insert into Etudiant ( nom , prenom , age ) VALUES
('agrari', 'Omar',20),('amine', 'houssam eddine',20);
insert into matiere (nom, coefficient) values ('math', 8),
('info', 1);
insert into classe (nom) values('G5');
insert into classe (nom) values('G1');
insert into classe (nom) values('G2');
insert into classe (nom) values('G3');
insert into classe (nom) values('G4');
select * from Etudiant;
 
insert into inscription(id_etudiant, id_classe) values(2,1);
 
desc note;
alter table note add column note float;
insert into note (id_etudiant,id_matiere, note) values (1,1,1);
 
select * from etudiant;
 
update etudiant set age=21 where id=1;
 
insert into enseignant (nom, specialite) values('tahar', 'dataStructures');
 
update enseignant set nom='allal' where id=1;
select * from enseignant;
 
update note set note=note+1;
 
update Matiere set coefficient =5 where id=1;
 
select * from matiere;
 
update Inscription 
set id_classe=1
where id_etudiant=1;
 
alter table note drop constraint note_ibfk_2;
delete from Etudiant 
where id =1;
 
alter table inscription add constraint fk_note_etu 
foreign key (id_etudiant) references etudiant(id) 
on delete set null;
 
alter table note add constraint fk_insc_etu 
foreign key (id_etudiant) references etudiant(id) 
on delete set null;
 
delete from matiere where id=2;
 
create table abscences(
id int auto_increment primary key,
id_etudiant int,
date_absence date,
seance_absence int);
 
insert into abscences(id_etudiant, date_absence, seance_absence) values (2,'2025-1-1', 1);
 
 
select * from abscences;
 
delete from note where note<10;
 
delete from abscences where id=1;
 
select * from etudiant where age>20;
 
select * from note where note>12;
 
select * from matiere where coefficient >3;
 
select * from enseignant where specialite='datastructures';
 
select * from abscences where id_etudiant=2;
 
select * from inscription where id_classe=1;
 
select * from note where id_etudiant=1;
 
select * from etudiant;
select * from etudiant where nom like '_g%';
 
 

LS0geW91ciBjb2RlIGdvZXMgaGVyZQoKaW5zZXJ0IGludG8gRXR1ZGlhbnQgKCBub20gLCBwcmVub20gLCBhZ2UgKSBWQUxVRVMKKCdhZ3JhcmknLCAnT21hcicsMjApLCgnYW1pbmUnLCAnaG91c3NhbSBlZGRpbmUnLDIwKTsKaW5zZXJ0IGludG8gbWF0aWVyZSAobm9tLCBjb2VmZmljaWVudCkgdmFsdWVzICgnbWF0aCcsIDgpLAooJ2luZm8nLCAxKTsKaW5zZXJ0IGludG8gY2xhc3NlIChub20pIHZhbHVlcygnRzUnKTsKaW5zZXJ0IGludG8gY2xhc3NlIChub20pIHZhbHVlcygnRzEnKTsKaW5zZXJ0IGludG8gY2xhc3NlIChub20pIHZhbHVlcygnRzInKTsKaW5zZXJ0IGludG8gY2xhc3NlIChub20pIHZhbHVlcygnRzMnKTsKaW5zZXJ0IGludG8gY2xhc3NlIChub20pIHZhbHVlcygnRzQnKTsKc2VsZWN0ICogZnJvbSBFdHVkaWFudDsKCmluc2VydCBpbnRvIGluc2NyaXB0aW9uKGlkX2V0dWRpYW50LCBpZF9jbGFzc2UpIHZhbHVlcygyLDEpOwoKZGVzYyBub3RlOwphbHRlciB0YWJsZSBub3RlIGFkZCBjb2x1bW4gbm90ZSBmbG9hdDsKaW5zZXJ0IGludG8gbm90ZSAoaWRfZXR1ZGlhbnQsaWRfbWF0aWVyZSwgbm90ZSkgdmFsdWVzICgxLDEsMSk7CgpzZWxlY3QgKiBmcm9tIGV0dWRpYW50OwoKdXBkYXRlIGV0dWRpYW50IHNldCBhZ2U9MjEgd2hlcmUgaWQ9MTsKCmluc2VydCBpbnRvIGVuc2VpZ25hbnQgKG5vbSwgc3BlY2lhbGl0ZSkgdmFsdWVzKCd0YWhhcicsICdkYXRhU3RydWN0dXJlcycpOwoKdXBkYXRlIGVuc2VpZ25hbnQgc2V0IG5vbT0nYWxsYWwnIHdoZXJlIGlkPTE7CnNlbGVjdCAqIGZyb20gZW5zZWlnbmFudDsKCnVwZGF0ZSBub3RlIHNldCBub3RlPW5vdGUrMTsKCnVwZGF0ZSBNYXRpZXJlIHNldCBjb2VmZmljaWVudCA9NSB3aGVyZSBpZD0xOwoKc2VsZWN0ICogZnJvbSBtYXRpZXJlOwoKdXBkYXRlIEluc2NyaXB0aW9uIApzZXQgaWRfY2xhc3NlPTEKd2hlcmUgaWRfZXR1ZGlhbnQ9MTsKCmFsdGVyIHRhYmxlIG5vdGUgZHJvcCBjb25zdHJhaW50IG5vdGVfaWJma18yOwpkZWxldGUgZnJvbSBFdHVkaWFudCAKd2hlcmUgaWQgPTE7CgphbHRlciB0YWJsZSBpbnNjcmlwdGlvbiBhZGQgY29uc3RyYWludCBma19ub3RlX2V0dSAKZm9yZWlnbiBrZXkgKGlkX2V0dWRpYW50KSByZWZlcmVuY2VzIGV0dWRpYW50KGlkKSAKb24gZGVsZXRlIHNldCBudWxsOwoKYWx0ZXIgdGFibGUgbm90ZSBhZGQgY29uc3RyYWludCBma19pbnNjX2V0dSAKZm9yZWlnbiBrZXkgKGlkX2V0dWRpYW50KSByZWZlcmVuY2VzIGV0dWRpYW50KGlkKSAKb24gZGVsZXRlIHNldCBudWxsOwoKZGVsZXRlIGZyb20gbWF0aWVyZSB3aGVyZSBpZD0yOwoKY3JlYXRlIHRhYmxlIGFic2NlbmNlcygKaWQgaW50IGF1dG9faW5jcmVtZW50IHByaW1hcnkga2V5LAppZF9ldHVkaWFudCBpbnQsCmRhdGVfYWJzZW5jZSBkYXRlLApzZWFuY2VfYWJzZW5jZSBpbnQpOwoKaW5zZXJ0IGludG8gYWJzY2VuY2VzKGlkX2V0dWRpYW50LCBkYXRlX2Fic2VuY2UsIHNlYW5jZV9hYnNlbmNlKSB2YWx1ZXMgKDIsJzIwMjUtMS0xJywgMSk7CgoKc2VsZWN0ICogZnJvbSBhYnNjZW5jZXM7CgpkZWxldGUgZnJvbSBub3RlIHdoZXJlIG5vdGU8MTA7CgpkZWxldGUgZnJvbSBhYnNjZW5jZXMgd2hlcmUgaWQ9MTsKCnNlbGVjdCAqIGZyb20gZXR1ZGlhbnQgd2hlcmUgYWdlPjIwOwoKc2VsZWN0ICogZnJvbSBub3RlIHdoZXJlIG5vdGU+MTI7CgpzZWxlY3QgKiBmcm9tIG1hdGllcmUgd2hlcmUgY29lZmZpY2llbnQgPjM7CgpzZWxlY3QgKiBmcm9tIGVuc2VpZ25hbnQgd2hlcmUgc3BlY2lhbGl0ZT0nZGF0YXN0cnVjdHVyZXMnOwoKc2VsZWN0ICogZnJvbSBhYnNjZW5jZXMgd2hlcmUgaWRfZXR1ZGlhbnQ9MjsKCnNlbGVjdCAqIGZyb20gaW5zY3JpcHRpb24gd2hlcmUgaWRfY2xhc3NlPTE7CgpzZWxlY3QgKiBmcm9tIG5vdGUgd2hlcmUgaWRfZXR1ZGlhbnQ9MTsKCnNlbGVjdCAqIGZyb20gZXR1ZGlhbnQ7CnNlbGVjdCAqIGZyb20gZXR1ZGlhbnQgd2hlcmUgbm9tIGxpa2UgJ19nJSc7Cgo=