Question

写出下列操作的SQL语句，update，delete，select，insert

Delete all Female students in Class 200501.
Query the students who are male or in Class 200503 with StudentID, Name, Sex and Grant..
Change the students’ grant to 500 whose grant are less then 800.
Add one student to the table.

Answer 1

delete students where Sex='Female' and Class='200501'
 
select StudentID,Name,Sex,Grant from students where Sex='male' or Class='200503'

update students set grant=500 where grant<800

insert into students(StudentID,Name,Sex,Grant,Class) values(123,'妞','Female',500,'200501')

Answer 2

对英文不懂，靠google翻译。

Delete all Female students in Class 200501.

DELETE FROM `table` WHERE `sex` = '女' AND `class` = '200501';
第二句英文不懂。
同上。
Add one student to the table.

INSERT INTO `table` (`id`,`name`,`sex`,`class`) VALUES (NULL,'张明','男','200501');

Answer 3

delete from students where sex='Female' and class='200501'
select * from students where sex = 'male' or class = '200503'
update students set grant='500' where grant<800
insert into students (StudentID,Name,Sex,Grant,class) values('3434','dd','male','522','200503')