Sql basics

create table student(
roll INT,
name Varchar(15),
dept Varchar(10),
mark int,
email Varchar(20)

);

insert into student values
(9,"Eklakh","AD",96,"[email protected]"),
(7,"Heena","CS",99,"[email protected]"),
(2,"Hina","BM",97,"[email protected]"),
(1,"Arnima","Civil",95,"[email protected]")
;
update student set dept="AD" where roll= 7;
select * from student;

select avg(mark) as avg_mark from student;
select min(mark) as min_mark from student;
select max(mark) as max_mark from student;
select sum(mark) as sum_mark from student;
Select Count(*) as c from student;
update student set dept="BM" where dept="Civil";
Select * from student;

Select dept ,avg(mark) as dept_avg_mark
from student
group by dept;