select *from [KHOA]
select	* from [lop]
select * from [Mon hoc]
select TenMH ,'So tiet' ,SoDVHT *15 As Sotiet from [Mon hoc]
select * from Sinhvien
select KHOA from lop
select Distinct KHOA from lop
select TOP 8 * From Sinhvien
select TOP 6 Percent * From Sinhvien
Select TOP 6 PERCENT * From Sinhvien
select * ,CASE Gioitinh When 1 then 'nam' else 'nu' end as Gioitinh from Sinhvien
select * from [Mon hoc] where SoDVHT =3
select * from [Mon hoc] where SoDVHT>3 or SoDVHT = 3