SQL-between和in的用法

select TSId from TblScore where TSEnglish<60

select * from student where TSAge>=20 and TSAge<=30 and TSGender=1
select * from student where TSGender=1 and TSAge between 19 and 29 

--第一种方式
select * from student where TClassId=1 or TClassId=2 or TClassId=3
--第二种方式
select * from student where TClassId in(1,2,3)

use nononodeleteImportant
select * from Customers where Country in('UK','USA')