单选题In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）A Immediately after the SELECT clauseB Before the WHERE clauseC Before the FROM clauseD After the ORDER BY clauseE After the WHERE clause

Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error? （）

A. remove the ORDER BY clause

B. remove the table alias prefix from the WHERE clause

C. remove the table alias from the SELECT clause

D. prefix the column in the USING clause with the table alias

E. prefix the column in the ORDER BY clause with the table alias

F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

A. ORDER BY SALARY > 5000

B. GROUP BY SALARY > 5000

C. HAVING SALARY > 5000

D. WHERE SALARY > 5000

标准SQL基本查询模块的结构是A）SELECT…FROM…ORDER BYB）SELECT…WHERE…GROUP BYC）SELECT…WHERE…HAVINGD）SELECT…FROM…WHERE

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

A. in the INTO clause of an INSERT statement

B. in the FROM clause of a SELECT statement

C. in the GROUP BY clause of a SELECT statement

D. in the WHERE clause of a SELECT statement

E. in the SET clause of an UPDATE statement

F. in the VALUES clause of an INSERT statement

A. Immediately after the SELECT clause

B. Before the WHERE clause

C. Before the FROM clause

D. After the ORDER BY clause

E. After the WHERE clause

对由SELECT—FROM—WHERE—GROUP—ORDER组成的SQL语句，其在被DBMS处理时，各子句的执序次序(43)。

A．SELECT—FROM—GROUP—WHERE—ORDER

B．FROM—SELECT—WHERE—GROUP—ORDER

C．FROM—WHERE—GROUP—SELECT—ORDER

D．SELECT—FROM—WHERE—GROUP—ORDER

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.

对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句，其在被DBMS处理时，各子句的执行次序为()

A.SELECT—FROM—GROUP—WHERE—ORDER

B.FROM——SELECT--WHERE——GROUP——ORDER

C.FROM——WHERE——GROUP——SELECT——ORDER

D.SELECT——FROM——WHERE——GROUP——ORDER