一、原题
View the Exhibit and examine the structure of the PRODUCTS table.

Using the PRODUCTS table, you issue the following query to generate the names, current list price,and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.
SQL>SELECT prod_name, prod_list_price,
prod_list_price - (prod_list_price * .25) "DISCOUNTED_PRICE"
FROM products
WHERE discounted_price < 10;
The query generates an error.What is the reason for the error?
A. The parenthesis should be added to enclose the entire expression.
B. The double quotation marks should be removed from the column alias.
C. The column alias should be replaced with the expression in the WHERE clause.
D. The column alias should be put in uppercase and enclosed with in double quotation marks in the WHERE clause.
答案:C
二、题目翻译Using the PRODUCTS table, you issue the following query to generate the names, current list price,and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.
SQL>SELECT prod_name, prod_list_price,
prod_list_price - (prod_list_price * .25) "DISCOUNTED_PRICE"
FROM products
WHERE discounted_price < 10;
The query generates an error.What is the reason for the error?
A. The parenthesis should be added to enclose the entire expression.
B. The double quotation marks should be removed from the column alias.
C. The column alias should be replaced with the expression in the WHERE clause.
D. The column alias should be put in uppercase and enclosed with in double quotation marks in the WHERE clause.
答案:C
下面是PRODUCTS表的结构:
使用PRODUCTS表,执行下面的查询来获取当产品打折25%之后价格低于$10的产品的名称,当前价格,打折后的价格。
查询会报错,错误的原因是什么?
A. 括号应该把整个表达式都括起来。
B. 双引号应该从列别名中移除。
C. WHERE子句中的列别名应该使用表达式替换。
D. WHERE子句中的列别名应该大写并且使用双引号引起来。
三、题目解析使用PRODUCTS表,执行下面的查询来获取当产品打折25%之后价格低于$10的产品的名称,当前价格,打折后的价格。
查询会报错,错误的原因是什么?
A. 括号应该把整个表达式都括起来。
B. 双引号应该从列别名中移除。
C. WHERE子句中的列别名应该使用表达式替换。
D. WHERE子句中的列别名应该大写并且使用双引号引起来。
WHERE子句中不能使用列别名,所以要用表达式替换掉。