COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following code works out the average of 3 test results and displays the results using a readable heading. However, there is an error in the code:SELECT name, (test1+test2+test3)/3FROM pupils
|
|
The values should be multiplied
|
|
|
The total should be divided by 100
|
|
|
The alias is missing
|
|
|
The SELECT statement should come after the FROM
|
Explanation:
There is 1 question to complete.