My Sql queries

CREATE TABLE student(admno int, name varchar(30),class int,sec char, rno int, address varchar(30));
desc student;
show tables;
insert into student values (1234,"aditi sharma",9,"A","4","SJE");
insert into student values (2605,"shreya nagpal",10,"D",7,"Jor bagh");
insert into student values (3712,"tanya verma",11,"C",21,"Malviya nagar");
insert into student values (5612,"krish gupta",12,"B",15,"Janki puri");
insert into student values (6532,"zyan malik",11,"E",40,"Rohini");
insert into student values (4031,"shivani mehta",9,"A",33,"Hauz khas");
select*from student;
select name , class from student;
select DISTINCT sec from student;
select name , class from student where class%9;
select * from student order by class,name;
update student set class=10 where name="shreya nagpal";
alter table student add marks int;
select name,class from student where name like 's%';
select max(class),min(admno)from student;
select min(class),name from student group by name;
select avg(admno),class from student group by class having avg(admno);
select sum(class),class from student group by class order by class desc;