Notes

1)
CREATE TABLE student (
id int primary KEY AUTO_INCREMENT,
Sname varchar(20),
Sgender varchar(20) DEFAULT 'Male',
Saddress varchar(30) DEFAULT 'Ktm'
);

CREATE table Grade (
Gid int PRIMARY KEY AUTO_INCREMENT,
Marks int NOT null,
Grade varchar(2) DEFAULT 'A',
stream varchar(20)
);
CREATE TABLE Result (
Gid int,
FOREIGN KEY(Gid) REFERENCES grade(Gid),
Sid int,
FOREIGN KEY(Sid) REFERENCES student(Sid)
);
INSERT into student VALUES
('','Nripesh', 'Male', 'ktm'),
('','Shrada', 'Female', 'ktm'),
('','Rita', 'Female', 'bkt'),
('','Himal', 'Male', 'ltr'),
('','Kiran', 'Male', 'ktm');
Insert into grade VALUES ('',99, 'A', 'BCA'), ('',70, 'B', 'BHM'), ('',60, 'C', 'BSW'), ('',90, 'A', 'BCA'), ('',70, 'B', 'BHM');

Select Sname from student join result on result.Sid=student.Sid JOIN grade on grade.Gid=student.Sid;
SELECT student.Sname, grade.Marks FROM student JOIN result ON result.Sid = student.Sid JOIN grade ON grade.Gid = result.Gid WHERE grade.Marks = ( SELECT MAX(Marks) FROM result ) AND student.Saddress = 'ktm';

Select Sname.student, grade.Marks from student join result on result.Sid=student.Sid JOIN grade on grade.Gid=result.Gid ORDER BY grade.Marks DESC limit 3 ;

SELECT S.Sid, S.Sname, G.Marks FROM Student S JOIN Result R ON S.Sid = R.Sid JOIN Grade G ON R.Gid = G.Gid WHERE G.Marks = ( SELECT DISTINCT Marks FROM Grade ORDER BY Marks DESC LIMIT 1 OFFSET 1 );



SELECT student.Sname, grade.Marks FROM student JOIN result ON result.Sid = student.Sid JOIN grade ON grade.Gid = result.Gid ORDER by Sname


SELECT student.Sname,student.Saddress FROM student JOIN result ON result.Sid = student.Sid JOIN grade ON grade.Gid = result.Gid where grade.Marks='A';


SELECT COUNT(Sname) FROM student JOIN result ON result.Sid = student.Sid JOIN grade ON grade.Gid = result.Gid GROUP BY student.Sgender;