i Question: Display the subject number, subject name, student number of student(s) who have received the highest mark in

[answerhappygod]

I Question Display The Subject Number Subject Name Student Number Of Student S Who Have Received The Highest Mark In 1 (118.18 KiB) Viewed 46 times

i Question: Display the subject number, subject name, student number of student(s) who have received the highest mark in this subject, and mark. If there are more than one students with the highest mark, show all of them. Sort your results based on subject number and then student number. ERD: enroll student mark sno subject subno subname quota sname telno Has prerequisite CREATE TABLE student ( sno character(10) NOT NULL, sname character(10), telno character (10), CONSTRAINT student_pkey PRIMARY KEY (sno) ); CREATE TABLE subject subno character(5) NOT NULL, submame character(25), quota Integer, prerequisiteno character(5), CONSTRAINT subject_pkey PRIMARY KEY (subno), CONSTRAINT subject_prerequisiteno_fkey FOREIGN KEY (prerequisiteno) REFERENCES subject (subno) CREATE TABLE enroll sno character(10) NOT NULL subno character(5) NOT NULL, mark integer, CONSTRAINT roll_mark_check CHECK (((mark>-0) AND (mark <- 100))). CONSTRAINT roll pkey PRIMARY KEY (sno, subno),