i Question: List all subject number and subject name for subjects that have the same quota as subject '31434'. Do not in

[answerhappygod]

I Question List All Subject Number And Subject Name For Subjects That Have The Same Quota As Subject 31434 Do Not In 1 (134.19 KiB) Viewed 41 times

i Question: List all subject number and subject name for subjects that have the same quota as subject '31434'. Do not include subject '31434' in the results. List results based on subject number in ascending order. ERD: enroll student mark + sno subject subno subname quota sname telno Has prerequisite CREATE TABLE student sho character(10) NOT NULL, sname character(10), telne character (10), CONSTRAINT student_pkey PRIMARY KEY (no) ); CREATE TABLE subject subno character(5) NOT NULL, subsame 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, subao character(5) NOT NULL, mark integer, CONSTRAINT croll_mark_check CHECK (((mark >-0) AND (mark <- 100))), CONSTRAINT roll_pkey PRIMARY KEY (sno, subno), CONSTRAINT enroll snofkey FOREIGN KEY (SHO) REFERENCES student (sno), CONSTRAINT croll_subao_fkey FOREIGN KEY (subno) REFERENCES subject (subno) ):