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 3: Give the lowest mark for each student, by
showing their student number and their lowest mark as 'mmark'. Only
list students who have enrolled for more than 3 subjects. List the
results in student number order.