** DS sinh vien cung tuoi voi sv Nguyen Thi Kim Anh sap xep theo ten

select n1.hodem,n1.ten,YEAR(GETDATE())-YEAR(n1.ngaysinh) as 'Tuoi'

from SINHVIEN n1,SINHVIEN n2

where n2.HODEM=N'Nguyễn Thị Kim' and n2.ten=N'Anh' and n1.NGAYSINH=n2.ngaysinh

order by n1.ten,n1.hodem

**DS sv thi lai CTDL cua khoa CNTT sx theo ten va luu vao ds moi

select SINHVIEN.MASV,hodem,ten,tenmonhoc,diemlan1,tenkhoa

into luuds

from SINHVIEN,DIEMTHI,MONHOC,LOP,KHOA

where SINHVIEN.MASV=DIEMTHI.MASV and

DIEMTHI.DIEMLAN1<5

and DIEMTHI.MAMONHOC=MONHOC.MAMONHOC and

TENMONHOC=N'Cấu trúc dữ liệu và giải thuật'

and SINHVIEN.MALOP=LOP.MALOP and

LOP.MAKHOA=KHOA.MAKHOA and

TENKHOA=N'Khoa Công nghệ thông tin'

order by ten

**DS sv nam khoa vat ly nho tuoi hon sv phan thi thu minh,sap xep theo ten

select n1.hodem,n1.ten,YEAR(GETDATE())-YEAR(n1.ngaysinh) as 'Tuoi',tenkhoa,tenlop

from SINHVIEN n1,SINHVIEN n2,KHOA ,lop

where n2.HODEM=N'Phan Thị Thu' and n2.ten=N'Minh' and n1.NGAYSINH>n2.ngaysinh

and n1.MALOP=lop.MALOP and lop.MAKHOA=khoa.MAKHOA and TENKHOA=N'Khoa Vật lý' and n1.GIOITINH<>n2.gioitinh

order by n1.ten,n1.hodem

**DS GV tung day 1 lop tink25 hoac tink26

select GIAOVIEN.MAGV,hodem,ten,tenlop

from GIAOVIEN,GIANGDAY,LOP

where GIAOVIEN.MAGV=GIANGDAY.MAGV and GIANGDAY.MALOP=lop.MALOP and (LOP.TENLOP='Tin k25ZZZ' or LOP.TENLOP='Tin k26ZZZ')

order by TEN,hodem

**DS sv dc giao vien nguyen hoang ha day

select SINHVIEN.MASV,sinhvien.hodem,sinhvien.ten,tenlop,GIAOVIEN.HODEM,GIAOVIEN.TEN

from SINHVIEN,GIAOVIEN,GIANGDAY,LOP

where SINHVIEN.MALOP=LOP.MALOP and LOP.MALOP=GIANGDAY.MALOP and GIAOVIEN.MAGV=GIANGDAY.MAGV and

GIAOVIEN.HODEM=N'Nguyễn Hoàng' and GIAOVIEN.TEN=N'Hà'

**DS ten mon hoc,sodvht cua khoa cntt

select tenmonhoc,sodvht,MONHOC.MAMONHOC

from GIANGDAY,MONHOC,GIAOVIEN,KHOA

where KHOA.TENKHOA=N'Khoa Công nghệ thông tin' and KHOA.MAKHOA=GIAOVIEN.MAKHOA and

GIAOVIEN.MAGV=GIANGDAY.MAGV and

GIANGDAY.MAMONHOC=MONHOC.MAMONHOC

**SV Ngo Viet Bac th lai nhung mon

select n1.hodem,n1.ten,tenmonhoc,diemlan1

from SINHVIEN n1,DIEMTHI,monhoc

where n1.HODEM=N'Ngô Việt' and n1.TEN=N'Bắc' and n1.MASV=DIEMTHI.MASV

and DIEMTHI.DIEMLAN1<5 and DIEMTHI.MAMONHOC=MONHOC.MAMONHOC

**