CREATE TABLE student ( sno character(10) NOT NULL, sname character(10), telno character(10), CONSTRAINT student_pkey

[answerhappygod]

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,
subname 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 enroll_mark_check CHECK (((mark >= 0) AND (mark
<= 100))),
CONSTRAINT enroll_pkey PRIMARY KEY (sno, subno),
CONSTRAINT enroll_sno_fkey FOREIGN KEY (sno) REFERENCES
student (sno),
CONSTRAINT enroll_subno_fkey FOREIGN KEY (subno) REFERENCES
subject (subno)
);
SQL Question 7:
Display the student number, student name, subject number, and
mark for students who received a mark higher than the average mark
for this subject.
Sort your results based on student number and then subject
number.