Query returning a "missing expression"
Date: Sun, 23 Jun 2002 00:44:00 GMT
Message-ID: <2e6ahusvucq5gcpd408tg72k3jfidmh5fb_at_4ax.com>
Here is my query:
SELECT SUM(max_enrl), AVG(max_enrl), MAX(max_enrl), MIN(max_enrl),
FROM course_section
ERROR at line 2:
What expression am I missing?
Here is the table:
CREATE TABLE COURSE_SECTION
WHERE term_id = 2;
ORA-00936: missing expression
(c_sec_id NUMBER(6),
course_id NUMBER(6) CONSTRAINT course_section_courseid_nn NOT NULL,
term_id NUMBER(6) CONSTRAINT course_section_termid_nn NOT NULL,
sec_num NUMBER(2) CONSTRAINT course_section_secnum_nn NOT NULL,
faculty_id NUMBER(5),
day VARCHAR2(10),
time DATE,
bldg_loc VARCHAR2(10),
loc_id NUMBER(6),
max_enrl NUMBER(4) CONSTRAINT course_section_maxenrl_nn NOT NULL,
CONSTRAINT course_section_csec_id_pk PRIMARY KEY (c_sec_id),
CONSTRAINT course_section_cid_fk FOREIGN KEY (course_id) REFERENCES
CONSTRAINT course_section_loc_id_fk FOREIGN KEY (loc_id) REFERENCES
location(loc_id),
CONSTRAINT course_section_termid_fk FOREIGN KEY (term_id) REFERENCES
term(term_id),
CONSTRAINT course_section_fid_fk FOREIGN KEY (faculty_id) REFERENCES
faculty(faculty_id));
Thanks Received on Sun Jun 23 2002 - 02:44:00 CEST