Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Teacher
create table student(stuid int,name varchar(20),class varchar(20),subject varchar(30),marks float,teacherid int foreign key References teacher(teacherid)); insert into student(stuid,name,class,subject,marks,id) values(101,'annu','bsc comp sci','computer',87,234); insert into student(stuid,name,class,subject,marks,id) values(102,'anshu','bsc comp sci','physics',77,244); insert into student(stuid,name,class,subject,marks,id) values(303,'anshika','B.A','history',65,255); insert into student(stuid,name,class,subject,marks,id) values(204,'pihu','bsc nm','physics',92,266); insert into student(stuid,name,class,subject,marks,id) values(103,'parv','bsc comp sci','computer',60,277); select * from student;
run
|
edit
|
history
|
help
0
SQL ASSESSMENT
Using Variables
Exam_1
dynamic pivot
TO find max marks of students
employee table
Gatoactual
SALESPEOPLE
sql test
hi