1.
SELECT HOTENSV, TENKHOA, DIENTHOAI
FROM SINHVIEN SV JOIN KHOA K
ON [Link]=[Link]
WHERE HOTENSV=N'Lê Văn Sơn'
2. SELECT [Link], [Link], [Link], [Link]
FROM GIANGVIEN GV JOIN HUONGDAN HD
ON [Link]=[Link] JOIN DETAI DT
ON [Link]=[Link]
WHERE HOTENGV=N'Trần Sơn'
3. SELECT [Link], [Link]
FROM DETAI DT
WHERE NOT EXISTS
(SELECT [Link]
FROM HUONGDAN HD
WHERE [Link] = [Link])
4. SELECT [Link],[Link],[Link]
FROM GIANGVIEN GV JOIN KHOA K
ON [Link] = [Link]
WHERE [Link] IN
(SELECT [Link]
FROM HUONGDAN HD
GROUP BY [Link]
HAVING COUNT([Link])>3)
5. SELECT [Link],[Link], [Link]
FROM DETAI DT
WHERE [Link]=(SELECT MAX ([Link]) FROM DETAI DT)
6. SELECT [Link], [Link]
FROM DETAI DT
WHERE [Link] IN
(SELECT [Link]
FROM HUONGDAN HD
GROUP BY [Link]
HAVING COUNT ([Link])>2)
7. SELECT [Link], [Link], [Link]
FROM SINHVIEN SV JOIN HUONGDAN HD
ON [Link]=[Link]
JOIN KHOA K
ON [Link]=[Link]
WHERE [Link]='Địa lý và QLTN'
8. SELECT [Link], COUNT([Link]) AS SỐ_SV
FROM SINHVIEN SV JOIN KHOA K
ON [Link] = [Link]
GROUP BY [Link]
9. SELECT *
FROM SINHVIEN SV JOIN HUONGDAN HD
ON [Link] = [Link]
JOIN DETAI DT
ON [Link] = [Link]
WHERE [Link] = [Link]
10. SELECT *
FROM SINHVIEN SV JOIN HUONGDAN HD
ON [Link] = [Link]
WHERE [Link] is NULL
11. SELECT [Link],[Link]
FROM SINHVIEN SV JOIN HUONGDAN HD
ON [Link] = [Link]
WHERE [Link]= 0