MYSQL

create table student(student_no int,class int, Name char(20), game char(20),grade char(2),supw char(20),GRADE1 char(2));
insert into student values(10,7,"Sameer","Cricket","B","Photography","A");
insert into student values(11,8,"Sujit","Tennis","A","Gardening","C");
insert into student values(12,7,"Kamal","Swimming","B","Photography","B");
insert into student values(13,7,"Veena","Tennis","C","Cooking","A");
insert into student values(14,7,"Archana","Basket ball","A","Literature","A");
insert into student values(15,10,"Aript","Cricket","A","Gardening","C");
select* from student;
select Name from student where grade="c" or GRADE1="c";
select Name from student where grade="a" and game="Cricket";
SELECT DISTINCT game FROM student;
SELECT SUPW FROM student WHERE name LIKE 'A%';
alter table student add column marks int;
update student set marks=200 where grade in('A','B');
SELECT* FROM student order BY SUPW;
SELECT* FROM student;