Examine the description of the MARKS table: SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: What is the result of the SELECT statement?()
- A、The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
- B、The statement returns an error at the SELECT clause.
- C、The statement returns an error at the WHERE clause.
- D、The statement returns an error at the ORDER BY clause.
正确答案:C
答案解析:有
微信扫一扫手机做题